Hi, I have a time sheets which calculates my weekly totals for working, holidays and over time based on a week ending format. What I can't seem to work out is how to copy previous worksheet and have it update the week ending date and carry over previous weeks over time and holiday hours automatically.

Is there any way of achieving this? Many thanks for any assistance.