Cross-Reference Lookup

[djwh5]

Dear All,
I am currently working on building a system that encompasses multiple workbooks, feeding out from one central workbook.
It's basically one huge workbook where all info is housed, and smaller workbooks used to present specific sets of information.
What I am trying to achieve is a form of lookup/index&match function, that does not require me to manually enter the column number reference to look in.
More specifically, if you look at the simplified tables below, I have the main database table, along with a satellite table I am creating.
I would like to be able to fill the satellite table based on the firm name, and pull the data for each column based on the header of said column.
So, once I were to enter the name of the firm I want to display, I could input a formula into the first column and then auto-fill for the others.
I have been messing around with a series of INDEX(xxx,MATCH(..... formulas, and can get them to work when I am specifying the columns to look in manually, but cannot figure out how to tell the formula to look based on the value in that table's column headers.
For example, in the Contact column of the Satellite Table, I have entered in the formula =INDEX($D$2:$D$6,MATCH(A10,$A$2:$A$6,0)), and this works, but is frustrating to complete for large tables, and does not auto-update if I shift around the formatting of the core database (which is one of the key reasons I want to get this working!).
It may be the case that this is where I need to be using array formulas, but I am by no means an expert and would love some guidance.
This is one of those problems which seems so devastatingly simple, and yet has me tearing my hair out!
I'm not sure if the copy past of the below will work, so I have also included a workbook attached with the below info
Thanks in advance for your help!



Core Database
Firm Type Account Size Contact Contact No. Relationship Location
Firm A Institutional $100 Mr. Smith aaa Client Edinburgh
Firm B Retail $50 Mr. Ricardo bbb Prospect Gatcombe Park
Firm C Retail $75 Mr. Keynes ccc Client Firle
Firm D Institutional $250 Mr. Marshall ddd Client Avignon

Satellite Table
Firm Contact Contact No. Account Size
Firm A Mr. Smith aaa $100
Firm B Mr. Ricardo bbb $50
Firm C Mr. Keynes ccc $75
Firm D Mr. Marshall ddd $250