Match different headings in different sheets and copy filtered data to correct heading

Good day,

I have template sheets and a data sheet. Some of the headings differ between the data sheet and template sheets, as well as th position of them:
example:
headings.JPG

So this is an example of what I'm trying to do:
-Find "Format" heading in the datasheet
-Copy filtered data under the "Format" heading
-Find matching header position ("Ownership")in Template
-Paste data as values under that heading
-Go to next one I specify (I'll do this in the code)

I've never done this one before if anyone has any ideas, please. The closest code I can change that I found is the following:

Please Login or Register  to view this content.

This would go better with a sample workbook. The template and a data sheet or two plus a mock up of the desired output would be a great help.

I did a couple of things:

First I removed all the extra lines in the tables. Tables grow automatically as you add data so you don't have to add the extra lines. The tables even "remember" formulas and formats and such.

I renamed the tables to match the pages. I use this naming convention in the code.

I also made a table out of the data so I could address whole columns at a time in the code, and made a table out of the heading names again because tables know how big they are, so if you add things to the "map" the code doesn't have to change.

The code loops through the sheets, looks at the table headers in the templates and tries to find it in Table_map. If it find it, it finds the corresponding table header name in data and copies it to the template table column.

In my code the TableName is base on the sheet name.

Please Login or Register  to view this content.

Since you are creating a table with a known name then change this line to:

Please Login or Register  to view this content.