Excel One-Click Cell Update

I already have the core formula written, but right now it only updates a single cell at a time. What I need is a simple, elegant way to make that same calculation ripple through multiple target cells whenever I click in row E. The results should come directly from the corresponding values that sit in row G, so the moment I tap any cell in row E the whole block updates in one go.

I’m open to whatever approach is quickest and most reliable—whether that means nesting the formula in a clever way, adding a lightweight VBA routine, or using a worksheet event. As long as the end result is:

• One click (or tap) in row E triggers the update.
• Every affected cell pulls its value from the existing logic tied to row G.
• No manual copy-paste or dragging is required afterward.

The candidate will be required to perform all work on my PC via AnyDesk.