Need Data sheet:

B6: =VLOOKUP($B$3,INDIRECT($A6&"!C4:Z14"),MATCH(B$5,INDIRECT($A6&"!C3:Z3"),0),0)

Copy across and down to C8.

Use the same technique to adapt the other tables.