Drop down dependent on previous filtered list - NOT SORTED ALPHABETICALLY

Afternoon all,

I have spent the morning trying to find a solution to my problem, and I'm optimistic that there is one although I haven't found it yet!
I have two tabs - one containing a list of clients, along with their 'status' (Active, Inactive) and other relevant information. I would like to be able to add to this list, should the company sign up any further clients. I would also like to be able to switch between the Active/Inactive status for each client (so a simple drop-down).

A second sheet is used to record the jobs that are underway, this sheet will build as each new job is added. I want staff to be able to select only 'Active' clients in this second sheet, from a drop down.

What I have found so far without VBA requires all active clients to be shown first in the filtered list which is not really practical as this list will change and other users will add to it.

Additionally, if VBA code is needed, I would like to add further drop down lists to additional columns on this second sheet based on specific information (New vs Recurring business, and a selection from 5 managers in charge). I need to ensure that the VBA code will not prevent these further drop-downs (using data validation) to be available.

Any help very much appreciated, thank you!

Kate

Do you have any sample workbook with which to start with. Remove any sensitive data and make dummy data if required

Sure, in xlsx format attached - further data validation to add, but omitted to simplify.

Thank you.