For clarification; in the excel sheet, I'd like to place my cursor on B2 and have it populate B2, C2, D2, E2 with the particular content control fields from the opened word document.

Then I could place the cursor on B3, run the macro which prompts me to open a file, select a different word doc and have it populate B3, C3, D3, E3 with the corresponding content control text from that document.

That is the final goal