linking cells within separate sheets

[Paula]

I have a workbook with 12 sheets - one for each month of
the year. Each sheet is then divided by weeks,
containing data for the last week of the previous month,
the current month's weeks, and the first week of the next
month. Is there any way to link the data on these
overlapping weeks? Say, if I enter data for the first
week of November on October's sheet - it will carry over
onto the November sheet, and vice-versa? I hope this
makes sense. Thanks in advance!

 

[Myrna Larson]

I think you should make a decision as to where you are going to enter the data
-- on the month where it belongs (my choice) or the month to which it is
carried forward or back.

If you enter all November data on the November sheet, etc, you would have
formulas in the 1st and last columns of each sheet, to retrieve the data from
the previous and next sheet, respectively.

There's another issue: how many columns are there on each sheet? Does it vary?
Each month (except Feb) consists of 4 full weeks and 1 or 2 partial weeks. So
the number of columns ranges from 6 (Feb) to 7 or 8.