Macro to copy two Sheets matching Source to each workbook in matching Destination Folder

Hi JLGWhiz,
I changed the code.

Now two issues are coming.

See the screenshot 1004 Error.

Your code is looking for the same file name where as I explained in the scenario it is not
the same name for workbooks both in Path 1 and Path 2. The workbook names are different in both Paths
I want to have the folder names matching for copying purposes. Hope it is clear now.

For sake of testing I made the filenames same in both Path 1 and Path 2 then other error comes up

See the screenshot - Error code if same file names

I think you have to tweak the code further please

I am also enclosing 1. Abcd folder both (Source and Destination) for testing purpose

Thanks once again for all your time and help