Index and Match across multiple sheets - is this the best way?

Hello all,
Hoping someone one can assist me. I'm an intermediate user of excel and have used several Match and Index functions before however for the life of me I can't get this to work. I've attached a sample spreadsheet. It shows two tabs one with the list of data and the other where I'd like the info to transfer to.

The data list on the first tab is actually the end result of quite a long macro. What I now need to do is present this in a more user friendly looking sheet.
So you will see the first sheet has a column of codes, there are 7 codes all up.

On the second sheet you will see Row Headings and I'd like to be able to insert the applicable data for each of the codes under the right headings.

If you can assist it would be much appreciated. Maybe I'm looking in the wrong place and there is a better way to do this?

Thank you

Hi Mate,

Welcome to the forum.

Looks like you need a Multiple results Lookup formula. I've attached a sample of what I've done. I presume this is what you're after. The only issue I have is when you change the code, the formula has to change... For example;

Please Login or Register  to view this content.

This is for 1LA

Please Login or Register  to view this content.

This is for 2LD

As you can see the ROWS component of the forumla has to be adjusted, and I'm not sure how to fix that. But otherwise it works as per the attached file.