copy the worksheet from one Excel file to another Excel file

Please help in Excel macro how can I copy the worksheet from one Excel file to another Excel file
I Have 3 excel file :
1.Master.xlsm
2.excel file with name in cell A2 (example Data1.xlsx) with worksheet on it "Blad1" in the folder directory in Cell B2 (example C:\Excel Data\Databron)
3.excel file with name in cell A3 (example Data2.xlsm) in the folder directory in Cell B3 (example C:\Excel Data\Kopie)

copy the worksheet "Blad1"from the file named in cell A2 to the file named in cell A3 then save this file
with a name in cell A9 and folder directory in Cell B9

if possible this file need to be open after file is save.

I made this VBA in an excel file called "Master"
i want it this way because the file name on cell A2, A3 , A9 and directory name and folder on B2 , B3 , B9 always changes
that why I dont want the name from the file and the directory folder on the macro

Please check this VBA

Please Login or Register  to view this content.

thanks in advance

I did not open your Master file - just change the one sheet name where indicated. Put the code into Master.xlsm

Please Login or Register  to view this content.