Multiple Index Match Problem

Hello everyone,

I am trying to solve a problem that requires a index match formula to select from multiple conditions vertical and horizontal.
Doing my head in a bit.

I have attached a sample of what I am trying to do.
The actual sheet has a lot more data on multiple sheets.
I need a kickstart in the right direction, because I am just turning in circiles.

Hoping to hear from you soon