Is there a way to combine multiple Excel files????

[caleblyn]

Let's say you have 10 files and you want to combine the 10 files a long with each sheet in that file, all into one file with the respective sheets.

File1 has Sheet1 and Sheet2
File2 has Sheet1 and Sheet2
File3 has Sheet1 and Sheet2

I want to make one file that has the above 6 sheets in it w/o having to copy and paste every one of them. The actual project that I am tring to do is closer to 50 files with 3 sheets in each file.

Thanks!!!

 

[caleblyn]

ttt

 

[caleblyn]

ttt

 

[texasalynn]

do a search on this forum for "combine files" or "consolidate" to get some very useful suggestions.