Vlookup & Hlookup combining separate workboo

Hi everyone,
I've searched the site and although I found several similar posts I couldn't quite see one that could help me.
I have data in two separate tabs (Location 1 & Location 2) of a workbook and I need to combine into a third bringing in the information in the various columns for each person. As you can see from my attachment the column positions change in each location and I have no control over this as I download this information and this is how it comes out.
I probably get lots more information than I need but in my combined sheet I only need to have a few columns with consisent headings.
Is there a way I can bring in this information using a persons reference id and also looking at the information contained in each column even though the column positions change?
I would greatly appreciate any tips