Quick demo of Excel drop down list, where items are hidden, after they're used.
Technique used Excel data validation, and Excel 365 FILTER function.
See detailed steps and get sample workbook on my Contextures site:
https://www.contextures.com/xlDataVal...
Or use this short link: myctx.link/used