Using Data/Validation trying to create a list based on our headcount stored
on another tab. However Excel telling me impossible.

Can I please have some suggestions on how to create list - I need the exact
names to be able to do Lookups

Thanks in advance