Hi,
I need your help again, I have some 25 files in a folder like File1,File1,File3,File4 etc. each file has many sheets, I am trying to create a new master file from the sheets of these files.
I take some sheets from these 20 files and create my master file.
everytime I open each and every file move sheets to my master file then do a copy paste values.
Is there a way in macro where I will give all 20 file names with the path and the sheet names from those file on the code so each time I run the macro the sheets are imported to my master file.
I have attached a excel file with details.
Bookmarks