Hi Kim,
In that case, provided you set up the LINK field as described in the link Tony posted, all you will need to do for changes to the # or rows is to change the range in Excel to which the named range referred to in the LINK field applies.

You also mention the need for this to be used in:
Do note that the paths in Word's LINK fields are absolute. If you move the Excel file, you'll need to change the link path in Word (eg via Edit|Links). Likewise if you provide the 'automated' report to others for their use - they'll need to change the links to point to their own Excel workbooks (and the named ranges within).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Tony,

Thanks again for the reply. I will email the data as adviced for your further evaluation. On second thoughts, and taking hint from Paul's note, if my desired output appears ideal yet complicated then I am open to a more practical approach, other than making the dynamic link option, to yet accomplish the auto-updating of the pre-formatted report in Word.

Let's give it time. I will consolidate files from my end and email you in time. Not really that urgent to make it soon. What I am getting now, of which I am confident of your assessment is that it is indeed possible, and so I will now consider this query solved ... and my pre-forum verdict as mere speculative at best.

...just can't wait. Ha ha ha. I just sent you today the pre-formatted .doc report for your evaluation. You are free to email Paul it that suits well too.

Cheers then and thanks. Will keep in touch.

Kim