I would like to create a workbook for weekly payroll timesheets and a summary page.

[pbebow]

I would like each week to look like the picture, with 6 employees, room to enter times for 7 days a week each. I have the general time sheet set up, but I want to create one for each week so that the date will update, as in the first week is week ending Jan 10, 2020 (using last years as example) dates Jan 4-10 listed, so the next week I would like it to look at the previous week ending date and add 1 to it to start over, so for a function it would say ='10-Jan-20'!A10+1 (referencing the purple square in first sheet) and the next date would come up to Jan 11, 2020 (the red square in second sheet)... but I don't want to have to go in and add that function for every 52 sheets, I want it to automate it to do it when I create them all, if that makes sense. Then for the payroll sheet (second screenshot) I would like it to have each employees name and have it go back per week to gather the number of hours and then calculate their pay based on their wages/per hour and how many hours they work and then give me a total payroll check to write. I have done it in the past but I usually go in and do it all by hand and I just know that their must be an easier faster way. I hope this makes sense... I tried to do the mini-sheet but couldn't get the add on to work.