Drop down input in EXCEL objecxt file within Word

[Nisio07]

hello all

Please bear with me as this may not even be the correct place to post.
Have a word document report/(Sample attached)
Existing macro already present to create labels
Now have embedded excel sheet to populate a table
This sheet has over 350 rows which I have currently placed in an adjacent sheet within the embedded.
Based on the value selected here the other columns in the embedded sheet (value 1... value9) will be filled from the drop down list (possibly via VLOOKUP).
However my gut feeling is that there is a better option - possibly via XML files/codes.
I appreciate that it is not right to have the code embedded in each report as there will be many hundreds of these reports created in working week but I could not get a remote/external workbook to work
I am adept enough at all things Excel/Word but am now starting to swim out of my depth.

I would appreciate any help in this matter.

Regards

Nisio