First time poster. Need your help. I've got about 500 excel that are in "C:\Test" Folder. I want to generate a macro that:
loops through all the files in the folder
For each excel file in the folder (1.xlsx,...)
copy all worksheets into a new workbook with the same filename as the...