Why not save a blank seven day version as a template? Assuming that
data needs to be moved from one sheet to another, that would be easy
to do - particulary as on the second sheet, the starting position would
be a formula (=equivalentCellOnDay1)