I work at a production plant. We have 3 shifts.

I have a workbook to track production.

On the opening sheet of the workbook I would like each supervisor to
input which shift (1, 2, or 3) they are inputting data for via drop
down box. Then on the next sheet - and this is where I need guidance -
how can I have the input from the 1st sheet (Shift Number) return a
list (from another worksheet further back in the same workbook) via
another dropdown box of the employees that are assigned to the
returned shift?

In other words, if the supervisor selects "2" from a drop down box
titled "Shift" on the first page how can I return a list of all the
employees who are on second shift to another drop down box on the
second worksheet in the workbook?

Lets call the workbook: ProductionBook.
The first page where the supervisor selects the date and shift number:
OpeningPage.
The second page where I need the guidance we can call:
ProductionInput.
The page with the employees info: Employees

Thanks a bunch,

Tim