Roster staff drop down list who meet criteria for shift

[Justmegan93]

Hi

I am trying to create a roster sheet which will make it easier to select staff from a drop down list

'Vehicles' and 'Routes' are selected from the drop down list made from named ranges in 'Data' sheet

'Required' is then populated from the vehicle selected in Column B

When selecting the staff they must have competency of the vehicle and have the route knowledge to the appear in a drop down list in column K

Does anyone know a way I could achieve this? Whether it is using formulas or vba

Or if you know any web pages that could help can you please link below?

I have attached a sample of the workbook

Thanks
Megan