To lookup corresponding value based on max value in all tables.
1] In C10, enter formula :
=INDEX(B3:S7,MATCH(A10,A3:A7,0),MATCH(MAX(INDEX(B3:S7,MATCH(A10,A3:A7,0),0)),INDEX(B3:S7,MATCH(A10,A3:A7,0),0),0)*COLUMN(A1:R1)+1)
2] Click A10 dropdown list to select other Lookup value for testing purpose.
Regards
Bosco