Copy Cells From One Worksheet To Another Worksheet Using A Macro

First off I will say that I'm a total noob when it comes to Macros in Excel. I understand what it does and how it works but just not knowing the coding to make it happen and would love to get come help if possible please!

Problem:
I'm looking to be able to create a macro that will look on "Worksheet A" and then copy the cells or contents of that column and input that unto "Worksheet B" in another column. Now one of the important things is that in "Worksheet A" I have cells named "supplier_id", "drop_ship_fee", "supplier_name", "product_id"....etc.... But in "Worksheet B those cells are not the same name and are named "id", "mfgid", "name", "manufacturer", etc....


Ex:
supplier_id = id
drop_ship_fee = mfgid
supplier_name = name
product_id = manufacturer


Now I have to make sure that the information that's on "Worksheet A" listed under "Column A (supplier_id)" is copied over to "Worksheet B" under "Column A (id)". Yes I know that I can just copy and past from one Worksheet to the other but I will have to be doing this with thousands of products every week and that's to time consuming. So I'm looking for a simple way to accomplish this.

I have attached the two worksheets so that you can see better at what I'm trying to accomplish. The "Worksheet C" is what the finished result would need to look like. Thank you in advance for any help on this issue, have been trying to figure this out all day and I'm sure it's very simple to accomplish.