Rotating Shift Schedule-Auto Populate

Also, I want to clarify that where the shift says AA1 this part will be somebody's name from the information sheet. I made it AA1 to remove personable data.

If it helps all of the days worked are unique. For example, a person only works one Tuesday night per rotation or month. In addition, a person only works one Tuesday Day per rotation or month.

Thanks for your help.