I am trying to create a data validation list to populate a list of names into specific calendar dates. The users enter unavailable dates on a second sheet and I want the list to populate on that particular calendar date with only the staff that are available. See screen shots.