pick-list with exclusive or meaning no repeats

I would like to know if I can create a pick-list of names such that as soon as I use one name in one cell, I cannot use that same one in another cell (ie the names already used would appear ghosted out in the pick-list) until I filled a set of cells with unique names within a certain range of rows and columns. The ones that don't get picked would get put in another list. The whole process needs to be repeated 3 more times where none of the names can be in the unchosen list twice in a row.
So Basically this is a soccer lineup for a 7-girl soccer team. The first column is a list of all 10 girls on the team. I need to make a lineup of the 7 girls for each quarter. I was thinking I could use a pick-list specially constructed such that as soon as I pick one of the girls for a position her name would either disappear from the pick-list or just be ghosted out. Also once the seven girls were chosen for that quarter the remaining three girls on the team would be listed on the side. That list could be used to make Excel not allow us to have a girl sit on the bench two quarters in a row. Would this be something that I need to use VBA to do?

(see attachment - Game 2 Quarter 1 for locations of pick-lists, then modify for Quarter 2)

Hello trodke,

Welcome tot he Forum!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!