There are 2 worksheets in this attachment.

The first sheet, you have to select a name from column C. The drop-down is dependent on the number of people per shift.

YELLOW = OPENING STAFFS
ORANGE = OPENING AND MID STAFFS
GREEN = CLOSING STAFFS

The second sheet does it automatically. You just need to select an employee E6 and the rest will populate.