Replace all matching sheets

Hi friends,
I am stuck at a point and need some help.
I have an excel file in which I update some information's, then I want to replicate the sheets in different folders and in different file.
I have a dummy sheet for reference, called "Master"
In column A I have inserted the folder location.
In column B I have inserted the sheets that will be copied from the current master file and replace in all the folders and files in location of Column A.

Means for example: in "C:\Testing Update\ " there are four folders with different name. each containing one or two files whose sheets are protected with password "Alpha2012". Now these files contains the exact sheet name that is present in the master sheet.(example : A,B,C,TCODE_P001 etc.) What I want is to unprotect the sheets, replace the sheets from master file without tampering any other sheets and again protect the sheet and save it. In all the files in the location "C:\Testing Update\ " then in the location "D:\Testing Update2\" (The password for all the files in this location is "Alpha2011")

Please help me. thanks in advance.
regards,
me

Hi JBeaucaire,
Thanks for your reply.
But somehow the sheets are not getting updated.
Please guide me.
Thanks in advance,
me.

Hi JBeaucaire ,
Thanks for the advice. I found the problem. Actually I have multiple folders in these locations under which I have the excel files.
C:\Testing Update\
D:\Testing Update2\

Now if the files are outside the folder then it's working perfectly.
But if they are in folder it's not getting updated. Any help on this?Actually I want any files under any folder in these locations to get updated. Otherwise everything is perfect.Thanks mate.
Also is it anyhow possible to add the file names in Column D that have been updated .
Thanks for all your help.
Regards,
Me.

Thanks mate.
I am marking it as solved.
best regards,
me