Hi,
I am looking for a VBA code that will do the following:

I have several files within one workbook (maybe fifty) that I would like to summarize all the data into another master workbook. Each file has data in the "summary" tab in cells A1 thru A76. I would the macro to extract the data into one worksheet column A,B,C etc. Can it automatically extract data from all files in a certain folder?

thanks for your help