Populate template with macro

[COGICPENNY]

I have a worksheet with MULTIPLE TABS that are in the exact same format for different Subcategory/Commodity names (the tab names). I need to take each of the tabs and populate the corresponding columns on the TEMPLATE.

Note: The following are the Tabs to Template column matching (since some of the column names on the template differ slightly):

Template Column A (Region-Country): Tab Column R (Region)
Template Column B (Supplier Name): Tab Column N (Supplier Name)
Template Column C (Supplier Number): Tab Column M (Supplier Number)
Template Column D (Diversity Status): Tab Column AE (Diversity Status)
Template Column E (Preferred/Allowed): Default Text "Preferred"
Template Column F (Contact Name): Contact Name
Template Column G (Contact Email): Contact Email
Template Column H (Sector): Sector
Template Column I (Site): Site
Template Column J (Subcategory): Subcategory Name
Template Column K (Commodity): Commodity Name
Template Column L (Commodity Code): Commodity Code
Template Column M (Description of Services): Commodity Description
Template Column N (Price List): Price List Available
Template Column O (Type of Contract): (MSA,SOW, Master PO etc)
Template Column P (Contract Entity Name): CONTRACT LEGAL ENTITY NAME
Template Column Q (Where Stored): WHERE STORED
Template Column R (ICD Number): TRIM ICD NUMBER

The IT-INFRASTRUCTURE tab and the template files are as follows:

Template: https://drive.google.com/open?id=1w0...IzxV6VtzdqibEr
IT INFRASTRUCTURE: https://drive.google.com/open?id=1hC...x1nhUuBXYYj-73

Thanks,
Penny

 

[COGICPENNY]

Not sure if the file url's are showing correctly, so I created a tinyurl for both files. REALLLLLLLLLLYYYYY need the help. Thanks, Penny


IT INFRASTRUCTURE FILE: https://tinyurl.com/y8po8pqn
Template: https://tinyurl.com/yaha5cj2

 

[Fluff]

Cross posted

Please supply links to all other sites where you have asked this question.

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.