Define name/array based on multiple conditions

[Ishcanter]

Sample.xlsxOverall I don't think what I'm trying to achieve is all that difficult, it's more that I know very little about VBA.

I'm constructing a theatre booking template and need to display with rooms across the columns and the timeslots down the rows for both the planning and display sheets.

I need to be able to select a specialty and then select an available individual based on the selected specialty - availability is defined by timeslot and each individual has only one specialty.

I have thought it would be easiest to define a name for each timeslot and specialty that contains a list of available individuals.

From my research around defining names and selections available through vba I think this is possible but haven't seen an example of it.

Is this possible/feasible?

If not, is there a better way to achieve the same result?