Hi - I am creating a workbook to support the periodic review of specific projects. Reviews are carried out every 6 months on a new work sheet. At the moment, the only way of creating a linked record of sequential reviews and worksheets is to copy the sheet in the workbook and then manually update it to the relevant contents of the previous review worksheet. This is both time consuming and prone to error. Ideally, I want to create a macro that does the following -

1) creates an open copy of the period 1 worksheet, as period 2.
2) changes the formulae in selected cells in worksheet 2, so that cells under the column heading "previous period comments", refer to cells in sheet 1 under the heading "current period comments".
3) write-protects worksheet 1, so that it can no longer be edited.

It seems such a simple thing......!