Personnel tracker

[BarnBrian]

I want to have a workbook where one sheet has say 100 names of personnel
on another sheet I will have say 6 worksites that have 8 personnel name cells for each. I want to have drop down lists for each cell so I can pick a name and add it to the worksite ( this name would not be available to the other cells. I'd then be able to see where all personnel are and also see how many are remaining to be available.
I hope I've made this clear.

 

[mumps]

We would need a little more information. What is the name of the sheet that contains the 100 names and in which column are the names found? What is the name of the sheet that contains the 6 worksites and in which column are the worksites found? Are the 8 personnel name cells for each worksite found in the eight columns directly to the right of the worksite names?