I've got my formula working:
=VLOOKUP(K8,INDIRECT($C$4&"!C$1:X$200"),22,FALSE)
except where I have a space in the sheet name... Is there a way of
modifying the formula to account for the space? I'm not keen on changing the
names as they relate to specific areas that are recognizable to a long list
of users, & to alter them changes meaning.