I have 10 file with the same sheet(1) name like "PL01" ..... "PL10"
I want to copy all sheet into one workbook, all sheets has just copied between sheet(First) and sheet(Finals).
This mean the sheets like this:
Before copy Workbook have: MAIN, First, Finals
Aftercopy Workbook have: MAIN...