Sheet To Sheet Activation Code

I am trying to set up vba as part of a macro that will do the following:
Open a master workbook

Open a data workbook( There will be a few of these to process)
Copy the data from a data workbook sheet (INPUT SHEET) to INPUT SHEET in the master workbook.
I will rename the master and then continue with the same process for the next data workbook.
I cannot copy/move the input sheet because of an MS bug whereby all of the sheet coding is lost whe you insert a sheet into a workbook.

I have set up a sheet in the master workbook that lists all of the data workbook names and paths I set the data workbooks up with a string variable name of TRGT.

I can get the coding to open the TRGT workbook but am having trouble getting the subsequent sheet commands to work in order to extract the data.

Here is a snippet of the