Populate automatic ROTA by date

Hi guys,

I'm trying to create a rota where it will automatically create and display the shifts of staff for the current week (Mon to Fri) and the following four weeks by entering the Week Commencing date (eg. 28/11/2016 will show this week, and the following 4 weeks. 05/12/2016 will show that week and the following 4 weeks ahead). This should populate from the shift codes manually entered in the Tracker tab for each staff.

The tracker is used to record instances of staff during the week. It also keeps count of headcount in the office and holiday allocations, and count of holidays.

How would I go about creating this? I have attached what I am working with with some helpful comments. Hope someone can get back to me.

any question, feel free to ask. Many thanks in advance, much appreciated.