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!