HI,
I have multiple Excel files with same worksheet names. I want a macros to merge the worksheets with same file name into new Excel File.
Example:
File Name A >>> Worksheet names >>> Annex1.1, Annex1.2, Annex1.3, Annex1.4 and so on
File Name B >>> Worksheet names >>> Annex1.1, Annex1.2...