I have about 20 excel macro files xlsm all containing a tab called "Freight". I need to have a new excel file (either xlsm or xlsx, I don't care) containing all "Freight" tabs from the 20 files, renamed in some way (because excel won't accept tabs with the same name). It could take cell B7 as name of the file (that field is unique).
I have tried the solution proposed in a previous thread (https://www.ozgrid.com/forum/f…e-workbooks-into-new-file) but it's not working. I have changed the path and the file type to ".xlsm".
I would really appreciate your help.