Create a list from all cells next to a certain value

[Nattpappa]

Hi!

I have tried multiple searches and multiple formulas but can't seem to get this one right.
I am close, but I don't get the results I am looking for.

Basicly, I want to create two separate sheets.
The first sheet will consist of 4x4 squares containing information about ID, Price, Rent, Pros/Cons etc, this is using the area A2:U125.
The second sheet is supposed to be a table that sums some of the information in the first sheet.

I basicly want to create a table from the sheet with the 4x4 boxes and I need to extract price, rent, ID and a few other variables.

The area with the 4x4 boxes is constructed like this:
A B C D E F G H I
| Description | Value | Description | Value | | Description | Value | Description | Value |
| Description | Value | Description | Value | | Description | Value | Description | Value |
| Description | Value | Description | Value | | Description | Value | Description | Value |
| Description | Value | Description | Value | | Description | Value | Description | Value |

So for example I have the description ID in A2, F2, K2 and then again in A8, F8, K8 and their respective values in the column to the right of them, B2, G2, etc.

What I want to do is to but them in a table like this:

A B C D E
ID | Price | Rent | etc | etc

I have tried multiple INDEX formulas combining it with the IF-function in different ways, but I am not getting it right.
I'm probably not that good at describing my issue but if anyone has any clue what I'm talking about and knows how to get around it I'd be happy for any helpful advice even if it's just a link to some tutorial or tip on which function to use.

Thank you!