Combine excel files
 

Hi
I have a large number of excel files that are emailed to me and I want to combine the first sheet of each excel file into a new excel file without opening any of the files. At the minute I have a file merger program to merge all the files but it hangs unless I open each file enable editing and save. Any ideas on a macro to do this?

Thanks