Combine Closed Sheets

D

DB100

Hi all

I am hoping someone can lend a hand

I have 13 spreadsheets that are all identical in format and structur
and contain information in the same places ( IE: Cell A1 contains
number ( can be different ) on all the spreadsheets. )

The spreadsheets are all saved in the same place, but have uniqu
names. But the names all contain the month they were created.

The question I have is this. Is it possible to Colate all th
information from the spreadsheets onto 1 "MASTER" list.

EG: All filenames in a certain location containing "JUNE" will have th
information stored in Cell A1 pulled forward to a NEW LIST in a ne
workbook.

Thanks for any hel
 
Top