copy multiple excel files data into one sheet?

[jayh]

I need some help copying data from 50 excel files into one sheet without having to copy and paste. I receive around 200 excel attachments a day and they all have the same data and header rows. I just need to put them all on one sheet without having to manually copy and paste each row into a master sheet. Any help would be appreciated. thanks

[jayh]

Please help!!!

[Kaak]

You should write a macro that loops through a dir. and opens the workbooks one by one. For each workbook you call a macro that opens the file, copies the data to an array, closes it again and the copies the array to the master workbook.

Is this help enough....?

or do you need the vba code....?

[jayh]

thanks, im pretty new to this so the code would help
thanks again

[Kaak]

Then I need 3 sample source files and the master file.