targeting variably named sheets

I need to compile rows of data from various sheets where the building number is replaced in each tab. example: For bldg 1 the sheet will be "1001-0000-information" and on building 2 it will be named "1002-0000-information". I have a loop that will loop through each of the files but I don't know how to point it at the correct sheet.

I have this written so far but I can't figure out how to name a **** that is partially variable and will change per sheet.

Please Login or Register  to view this content.

The tab is named by the building, which is out of my control.

FWIW:

Please Login or Register  to view this content.