copy specific columns from variable sheet names to specific sheet tab

Let me restate what the requirement is before I start and then when you confirm, we can start working. You receive a sheet with a tab Workings. Sometimes it contains the Master Sheet with headers only, sometimes it does not. You want to copy only certain columns from workings to master.

How does this sound for a solution. You have a spreadsheet with a Master "template" sheet on it. You import the data from the working sheet. This can be done by taking the working sheet file and putting it in the same directory with the spreadsheet and letting the code do the work of importing it. We would have to know the working sheet file name. Either you will have to rename it to a specific name, or it will have to have a predictable name such as a fixed name with a date stamp.

The other thing you can do is open the working file and copy and paste the data in. Sometimes this is easier.

You will also have to come up with a "map" to tell the program what columns you want to copy and where to get the column from. For example if you want to copy DESIGNATION you need to tell the program to go to column G on the workings sheet and put the result in column E of the Master sheet.

You will not need a map if you want everything on the master sheet to be copies and those columns exist with the same name on the workings sheet. The program can look for that name header and copy it. If it can't find that name header on the workings sheet, it will skip it.

So please confirm how you get the file and if you want the program to import the data or use copy / paste. Also confirm that you want everything on the master sheet filled in - the program will find where that column header is on the workings sheet. Finally confirm that the column names on the master and workings sheet are identical.

Oops. I see that you already have the map. Do you want to leave columns B & C blank or remove them so Invoice number is in column A and Code article is in column B?