Creating a Data Validation based on another Data Validation
Meaning that when you select from a drop down from the first the second will be filled with the list that is corresponding to it.
You need to create two names (Formula > Name Manager), one has this formula
The other one has this
The create Data Validation to “List” first name on a cell, and another Data Validation to list the other one