This doesn't eliminate the problem of needing to access/type in all those
different workbook files... :(

"Eric" wrote:

Marguerite,

You could use INDIRECT, but you'd still need to type in the file names that
you wanted.

Eric


"Marguerite" wrote:

I have a large number of workbooks with identical structures. I want to get
information from a location on a particular sheet in every one of these
workbooks, and list it in a new workbook. Any ideas of how to do this
without having to copy-and-paste from each of the locations or manually enter
the source for each of these books?

Thanks!