I have an Excel 2003 workbook with multiple worksheets, each of which has a
defined external data input of a text file. This is used as a template to
gather real data from data logs, so when a user refreshes the data, they
select the text file they want, and it is placed according to the pre-defined
query.

The query obviously remembers the current name, which is shown each time the
refresh operation is attempted. How do I automatically place that name on a
summary sheet elsewhere in the book? Right now, it is a painful manual
process of "refresh", "copy", "cancel", select target cell (in a different
WS), "paste", and I have ten of these puppies, so it gets old. I suspect I
will have to use VB, but any info to get me started will be appreciated,
since I have not used VB at all before (I am a programmer, so this is not an
issue- I just need to figure out the fastest way to get there rather than
muddle through large amounts of reference material).
Thanks!
S.