I have multiple workbooks spanning from "ABC1" to "ABC100", as well as "XYZ1" to "XYZ100" in a folder called "Cases".

I would like to create a "Master" workbook in the folder "Cases", where a code runs that copies values from workbook "ABC1" Cell A1 in Sheet 1, as well as from Cell A1 in Sheet 2, and pastes these as values into "Master" workbook Sheet 1, Cell A1 and Cell A2 respectively. Once completed, sheet 1 in "Master" workbook must then be named "ABC1".

The same must be done for values in workbook "ABC2" to "ABC100", as well as "XYZ1" to "XYZ100". The final result will see "Master" workbook have 200 worksheets/tabs, ranging from "ABC1" to "XYZ100", with each containing a value in Cell A1 and Cell A2.

PS: Each excel workbook is in a different folder in the "Cases" folder. e.g. the "ABC1" workbook is in a folder called "ABC1".

Your assistance is greatly appreciated.