Hello Excel Community!
I am working on creating a workbook that will allow shift selections to be entered from new hires, compared to availability and then logged and space removed from the availability. Rather than create a mess of a workbook that would be torn apart i am asking for assistance on the best was to complete this. I would appreciate any expertise you can share. Below i have attached a idea of my vision. Also if you happen to create the sheet please help teach me by providing the process below if able.

Also if you are the savior of excel it would be excellent if the selections made could lookup on the master shift list to identify the one selected.

Pick Your Shift Structure.xlsx

Other than being eternally grateful i will add feedback for assistance