No, the workbooks have names of the places where the equipment is located.

"Bernard Liengme" wrote:

Do the workbooks have a names that look like a series?
Like: Jan , Feb, Apr...
Or: Book1, Book2, ....

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave Young" <Dave wrote in message
...
How can I automate collecting information from 30+ workbooks that all have
the same format (i.e. Cell B25 in all workbooks has the same type of
information) and generating a report or another spreadsheet from the
collected information.

For example, all of my workbooks contain information about equipment at 30
different locations. I would like to query all of the workbooks and get a
list of what is contained in Excel Cell B25.