Hi All

Hopefully someone can help with this one. I need to copy sheet1 from all workbooks in a folder :

i.e. "c:\steel_monkey\excel\example\" may have 4 different workbooks in it, is it possible to open each of these and copy sheet1 into my master spreadsheet using VBA

any help would be appreciated

Thanks!