Employee Shift Schedule

Hi Guys, I am a basic excel user and I need some help creating a team shift schedule for my 3 teams.

So I have 3 Teams as mentioned a above. Team 1 , Team 2 and Team 3. There is a Day Shift, Night Shift and Day Off.

My 1st Question:

This is the pattern of how the shifts work https://www.screencast.com/t/AhXJceYD . For this I want to create a function or formula. When I choose "team 1 day" then it auto populates the below cells or above to "team 2 off" and "team 3 night". And vice versa, so which ever 1 I choose in the shift pattern it autocompletes the cells below or above.

My 2nd Question:
What is the best way to setup my calendar to accommodate the above process because this is how the schedule pattern looks over a 2 week period starting on a Wed. https://www.screencast.com/t/0Ine3Lb4vNr

I want to know if there is a way to automate alot of the process because this if the same every year but the shift pattern can easily change as well.

I hope the above makes sense. Thanks in advanced.

Any help will be appreciated.

Best Regards