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.