Index-Match formula tied to Cell value

I am trying to get an Index-Match formula to search a different sheet depending on the value selected in a particular cell using a dropdown list.

See the attached workbook.


Thanks

Jim O

=vlookup(c8,indirect(c5&"!a2:g33"),6,)

=vlookup(c8,indirect(c5&"!a2:g33"),5,)

keeping with index /match
in c11
=INDEX(INDIRECT(C5&"!F$2:F$33"),MATCH($C$8,INDIRECT(C5&"!A$2:A$33"),0))
in c12
=INDEX(INDIRECT(C5&"!E$2:E$33"),MATCH($C$8,INDIRECT(C5&"!A$2:A$33"),0))