Grabbing data from multiple workbooks

[erniepoe]

Hi all,

I have a folder with about 35 spreadsheets, each with a different name. Is there a way that a formula or macro can go into every spreadsheet and grab either a certain cell or a range of cells (which would be the same for each spreadsheet) without having to go into each one individually and copy-paste?

Thanks for any help,
Ernie