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]