Pullin back data in specific orders from varied report

Hello,

Sorry to post in here, i reckon my questions is a pretty basic one for most of you but im somewhat useless with figuring things like this out on Excel.

I do paid online marketing and i use Excel. In order to keep up with what we are spending etc, we have this excel busget tracker in which we pull reports from LinkedIn and other channels and then past this in. and then formulas in that sheet create a budget tracker of sorts where we can see what we've spent, how much we have left etc.

The issue is that with LinkedIn, every couple of months or so they make changes to the report we export. The data and column names are always the same but the order they are in always changes. We also have multiple accounts on LinkedIn and for whatever reason the order of the columns in different accounts is different despite being the same data, and annoyingly LinkedIn Doesn't give us the option of defining this order.
So obviously when we go to paste this data into our report as the columns are all over the place it doesn't match up with our formulas and everything bugs out.
so at the moment I'm having to go in and manually copy and past individual columns into the right order, with about 30-40 different columns and 10 or so accounts this takes way too long.

My idea is to see if we can create some kind of excel sheet, where using some kind of formula, it will look into the entire sheet and only pull out the columns we need, it will then organize these columns for us and we can then paste that into our report in the right sequence.

So for example if the columns need to be in a-b-c order but the report is in b-c-a order and another in c-b-a order, is there a formula to pull out a-b-c in whichever order and organize it into a-b-c

I hope that makes sense and I'm dead sorry if this is a silly questions for a much more advanced forum.

all the best

(I'm assuming its V lookup btw i just haven't been able to make it work)

Use this Formula

Please Login or Register  to view this content.

Where LinkedIn is the Sheet containing Data from Outsource (Headings in first row)

and Home Sheet is the Sheet where data will be formatted as per the headings.

Use the above code in Cell A2 and drag it laterally and down depending upon the rows in the external Data.

I am attaching the reference Sheet.

Test.xlsx

Please Use this Code

Please Login or Register  to view this content.