Macro to copy Sheetnames shown under Col C from one Path to another Path

Dear Experts,
I am using Excel 2010

I wish to copy sheets (From) Path to another (To) Path
I have made a small scenario on the sample attached

My requirement is
Copy From Path C:\Test\L1\

The macro when run should open the workbook name shown under Col B, copy Sheetname under Col C
and the close the Workbook

Copy to Path C:\RPT\BGT\CLT\
There are many sub folders shown under Col I
Each sub folder has a workbook, names shown under Col J

Sub Folder names and Filename1, 2 etc is used for explanation purposes only
Each workbook has one to many sheets

The macro should copy the sheetname under Col C to each workbook
If the sheet exists in the Copy to Path it should be replaced

Hope this is clear
TIA
Pnasir

Dear Experts,
Any help to my post please

Regards
Pnasir

Hello All,
Sorry I forgot to upload the sample
Please see it here

TIA

Hello All Experts,
Any possible solution to my problem please?

TIA

Dear Sintek,
My system was down so could not check your reply.

Please see my comments under your queries.

After Opening CCP.xlsx and processing above, ATP.xlsx must be opened
Yes this is correct

When this happens, sheets "SPD","CCM","DN" from ATP.xlsx must be copied as per above?
Sheets SPD and CCM is in workbook CPP.xlsx
Sheet DN is in workbook ATP.xlsx

This will find that the sheet already exists????
The macro should check before copying in the ToPath.

And if it should overwrite that sheet then surely it defeats the object...
It will overwrite the old with the new ones

I will be using this macro for updating the latest Sheets from Path 1 to Path 2. The sheetnames and workbook names will always be the same so if the old sheets are there in Path2 it should overwrite with the new ones. Hopes be it is clear now

Thanks for your time and help

Hello PCI,
Thanks for your code
It highlights this line with Variable Not Defined error

BBB = FileDic.Item(K).Name

Can you please check?
Regards