Dear JLGWhiz,

Please see the scenario

Path 1 - C:\Source\Master\ with following folders as follows

1. Abcd
2. Efgh
3. Hij
4. Klm
5. Nopq
6. Rstu
7. Vx
8. Wyzab
9. Cdefghi
10. Jkl

The above folders will each have a workbook which has many sheets names can be any name out of which two Sheet names are Dept and Result. I want the Dept and Result sheets only to be copied to all workbooks in matching folders in Path 2

Path 2 - C:\Destination\ with following folders as follows

1. Abcd
2. Efgh
3. Hij
4. Klm
5. Nopq
6. Rstu
7. Vx
8. Wyzab
9. Cdefghi
10. Jkl

The above folders each will have one to many workbooks which has many sheets where the two Sheets (viz. Dept and Result) from Path 1 should be copied in the last in each workbook


There may also be other folders and files in Path 2 which I don’t want.


Only folder names matching in both Path 1 and Path 2 are required for copying

My objective is to match the folder names in both Path 1 and Path 2 and do the copying from Path 1 to Path 2

Hope it is clear now

Thanks for all your time and help