Variable Data Validation for LIST

Hi GHarwood and welcome to the forum,

See the example where I've changed your data a little so I could do Advanced Filters on it. Then*using some VBA code to rebuild the name list it will do what you want. Look at the VBA code behind the sheet and in the module.