I have a small problem times 100.

I need to make a report pulling together data from six other .xls files. I
am looking for a way to prepare tables and graphs which link to external
files. Then in theory if I was to change the file - the report would remain
the same, the figures would update.

I am hoping I can make the links relative (same folder), so I can then use
the same named files in other folders, and simpluy drop the report in - and
things just magically work! Is this possible? Can you suggest a way of
looking up these tables?