Data Validation using multiple dependent drop down lists

I am trying to make a list of monthly trips for our transport company.

I have been trying to use Data Validation drop down lists to make the entries into the list from a set of data.

The idea is that you select the Account, then the Client Name (limited by the Account), then the Pick Up (limited by both the Account and Name), and finally the Drop Off (limited by all three).

The problem I am having is that when I use the list it is SLOW. I know that there are (I hope) faster ways to get the results I need.

The workbook however is to big to post, so I have trimmed it way down.
The attached workbook has the basics in it.

On the 'Daily' tab is the list I am trying to make.
On the 'List' tab is the data I am using.
On the 'Sheet4' tab is the sort/formulas (most of them, just realized that this version still has some of the formulas on the 'Daily' tab).

I have tried to use the Indirect and the Offset formulas in the DV source, but the results still need to be filtered somehow to eliminate duplicates.

Would I need to create sub-lists of the data for each of the possible combos and sort them. And then somehow have the DV reference the correct sub-list?

I have heard of using Pivot Tables to sort this kind of mess, but how would I connect that into this list?

Any and all help will be appreciated.

Attachment 200700

See attachment, validation for Client Name (limited by the Account), then the Pick Up (limited by both the Account and Name) should be OK.

That works great!

But how are you doing it? I do not see any formulas, either in the Data Validation or on the sheets... And the named ranges all look the same.

Are you tricking me? (LOL)

Seriously, how are you getting the lists to update? And can I use this on the Drop Off column?

The datavalidation is all done by VBA, the code is heavily inspired (read "copied from") some code previously posted by forum guru "jindon".
The named ranges are not used for the validation (but i left them in case you need them somewhere else)
I suppose this can be extended to the Drop Off column, but i got stuck in the extra complication of the code.
As it stands now, it's a Dictionary in Dictionary in Dictionary.

I swear that I checked the VBA...

I will be going over that later (now that I know where the code is...)

Long and very frustrating day at work, and now that I have a solution that works; IT'S QUITTING TIME!!!

P.S.: Thanks for all of your help.