Excel to Excel

[amstereo]

x-no-archive: Yes

I need to automatically move data from a series of individual Excel
worksheet files to a common Excel worksheet in another file.

Essentially the user would be prompted to ask for the location of
the first document, and the VBA macro would copy the specific cell
contents from the first file, and paste into another worksheet.

There would be a loop that would cycle through the input files,
pasting the data into the common output file. Does anybody have any
suggestions on how to write this Excel macro?

Thanks in advance,
Jeff