Copying Data from certain tabs which have different headers and are updated multiple times a week into a separate Master Tab that has a table

[Bramsey77]

Hello All,

I really hope you guys can help. I am having a really hard time making a macro for this repetitive task that has to be done constantly. I have 8 tabs I need to pull data from and I need to copy all the data from those tabs and enter it into a master tab that has a table which is generating Pivot tables. The Tabs have different headers but all the headers are in the master table already. I just need help coming up with a macro that would copy the data from each tab enter it into the master tab with the table and put the data in the right position according to the headers. Below are the headers and the last picture is where they need to be copied into.

 

[Crystalyzer]

It would really help if you could identify which worksheets have which headers.

 

[Crystalyzer]

If you standardized the column layout you can easily create a copy and paste macro to take a row from each and paste it to the master. By standardize, I mean all the columns in the feeder sheets are in the proper place (column) where it appears in the master. You can achieve this by inserting blank columns and hiding them in the feeder sheets. See below for the columns that should be inserted and then hidden.

Order Table

Book11
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Project Key	PK Description	Applicant IO	WBS/Order	Order Description	Status	Actual YTD 2021 [ IA ]	Expectation 2021 [ K ]	Expectation 2022 [ M ]	Expectation 2023 [ O ]	Expectation 2024 [ Q ]	Expectation 2025 [ S ]	Expectation 2026 [ U ]	Expectation 2027	Plan 2021	Month to Date
Order Table

No columns to insert, all columns aligned

Book11
	A	B	C	D	E	F	G	H	I	J	K	L	M
1							Actual YTD 2021 [ IA ]	Expectation 2021 [ K ]	Expectation 2022 [ M ]	Expectation 2023 [ O ]	Expectation 2024 [ Q ]	Expectation 2025 [ S ]	Expectation 2026 [ U ]
2	Project Key		Applicant IO	Order		User Status IO	USD	USD	USD	USD	USD	USD	USD
1

One column inserted (column G) that should then be hidden

Book11
	A	B	C	D	E	F	G	H
1								Expectation 2021 [ K ]
2	Project Key		Applicant IO	Order		User Status IO		USD
2

Eight columns inserted (columns G - N) that should then be hidden

Book11
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1															Plan 2021
2	Project Key		Applicant IO	Order		User Status IO
3

No columns to insert

Book11
	A	B	C	D	E	F	G
1							Actual YTD 2021 [ IA ]
2	Project Key		Applicant IO	Order		User Status IO	USD
4