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.