Auto copy contents from sheets 2 and 3 to sheet 1 if column heading contains set words

Hi

I am trying to figure out if there is a simple way to replicate the contents of multiple sheets into one sheet based on the headings of those multiple sheets.

Please find attached an example (test.xlsx) of what I am trying to achieve.

In sheet 1, I have the headings of A-F out of order.

In sheet 2, I have the headings of A, B and C with various numbers underneath each heading.

In sheet 3, I have the headings of D, E and F with various numbers underneath each heading.

What I am trying to do is:

• Get the contents under the headings of sheets 2 and 3 under the correct headings of sheet 1.
• As I make alterations to the headings in sheet 1, the information underneath updates automatically (e.g. switch headings around).
• Make sheet 1 to be live, in that, as I make changes (or add more or delete rows, or paste information) to sheets 2 & 3, that the contents of sheet 1 would automatically update.

If anyone out there can help, I'd be most appreciative.

Cheers