Margureite;
You can link the workbooks. Just go to the new workbook and click "=" then
go to the spot in the other workbook and click on the cell you want to
transfer over, then press enter. Whenever you change it in the original it
will update in the destination.

"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!