I want to be able to relate the tables to the one previous to it.
If 'James' is picked from CLIENTS, I would like only 'James Job 1' and
'James Job 2' to be shown from JOBS.
If 'James Job 2 'is picked, then only 'James Job 2 Function 1' and 'James
Job 2 Function 2' and 'James Job 2 Function 3' to be shown from FUNCTION.

I have tried the INDIRECT function and made it work with 2 tables, but can
not seem to make it work with 3 tables.

eg:
CLIENTS
James
Arthur

JOBS
James Job 1
James Job 2
Arthur Job 1
Arthur Job 2

FUNCTION
James Job 1 Function 1
James Job 1 Function 2
James Job 1 Function 3
James Job 2 Function 1
James Job 2 Function 2
James Job 2 Function 3
Arthur Job 1 Function 1
Arthur Job 1 Function 2
Arthur Job 1 Function 3
Arthur Job 2 Function 1
Arthur Job 2 Function 2
Arthur Job 2 Function 3