Want to pull data by searching for the column name into another sheet

[ashleighspencerTMC]

I want to be able to drop information into sheet 1, and automatically in sheet 2 it searches for the column name and inputs the data below that?

In more detail, I want to be able to drop multiple different invoices into sheet 1, the problem is they are never laid out the same.

I'm hoping to have a solution where no matter what format the invoice is in, I can drop it into sheet 1 & sheet 2 automatically finds the information based on the column names I have put there?

Example 1 & 2 show the same information just in different formats.

So sheet 2 will search for an example VAT no matter where on sheet 1 it is and will input the information below the column header in sheet 2.

 

[ashleighspencerTMC]

I've done this now!