I have 6 named ranges.

"Sector" Job sector category of each individual, which is a normal named range featuring 5 different sectors:

And the five sectors:
"Administrator", "Manager", "Waitress", "Kitchen" & "Bar"

These are dynamic named ranges which I calculate using =OFFSET(Sheet1!$A$1,0,0,MATCH("*",Sheet1!$A:$A,-1),1)

I am trying to create a cascading dropdown list whereas the 2nd list available is dependent on the sector chosen in the 1st dropdown list in E3.

I would usually use =Indirect(E3) but as the five sectors are dynamic this does not work.

Is there a solution to this problem?

Thanks in advance