Can you please help.
I'm trying to find a macro that would:
I have about 25 - 50 Excel Workbooks (same folder) that I need to merge into one workbook,
but, I need each Workbooks to be on a separate tab.
so, I should have 25 tabs to 50 tabs. (Workbooks 1,Workbooks 2,Workbooks 3,...)
Any help is appreciated.