Macro to Merge different Excel files into one

Of course, but are you 100% positive there will be no duplication of tab names between any two sheets? Absolutely 100%? It really makes me nervous opening 60 "unknown" files and moving in the only sheet in each and not using a sheet-naming method we know in advance won't result in duplicate sheet names.

Please advise.

I've highlighted in blue in my post above the line of code you could remove to have the sheets NOT be renamed prior to importing.

NOTE: Please don't use the QUOTE button, it duplicates my post completely inside of yours for no reason. Just use the QUICK REPLY box below. Use the QUOTE if you do want to quote something specific I've said, but only leave in that portion, remove the rest.

This makes thread much less cumbersome to read.