For a monthly turnover sheet, I am trying to work out a way to copy a work sheet in such a way that a date formula relates to the same cell in the previous work sheet.

The challange is to do this REGARDLESS of the name of the work sheet. I.e., using a 'PREVIOUS SHEET" argument.

Does anyone have any clue?

About me..:
Upper average. Can't do any programming (wrote a macros once, though)
Profession: Business executive.