I am new to Dynamic view. Can I create dynamic drop downs with it? If so how?

I have a huge list of employees with their associated manager. I want to create a drop down across all of my sheets for employee name and I want the list to shrink based on the state they are entering data for. Each state should only see it's own so I assume I have to create workspace for each state or does Dynamic View fix that too?