Wasnt sure what to put in as the subject.

Sheet 1 is my compiled data sheet. I have 12 other sheets with each
representing that months data. Sheet 1 is linked to each months sheet picking
up all the totals for that month and putting them in a table.

Eg. Sheet 1 represents period 1
Sheet 2 represents period 2
and so on

In sheet 1 I have a number of lines referring to the end of period or has
the end of month date

Example

This data represents €¦€¦€¦€¦€¦. to the end of period 3 of FY 06-07
Comparison data for period 3 FY 05-06
or This data €¦€¦€¦. to 30 September 06


Instead of having to go through and manually change all these dates and
period numbers in sheet 1 at the end of each month I want to know how I can
have these lines automatically update at the end of each period.