3rd level drop down list with hyperlink to sheet in workbook

I think, maybe you try name single cell not a range. CountryLookup is range now.

=INDIRECT(VLOOKUP(D9,INDIRECT(VLOOKUP(B9,CountryLookup,2,0)&"Lookup"),2,0)&"List") = result is text with spaces and it is not defined as name.

but maybe I'm wrong

I tried all links and it doesn't work.

edit:
ok, I'll try build something like your wkb, but a little later