I have the following entry in Worksheet 2, Cell AT8:


=IF(AS8="win",1+'Week 1'!AT8,'Week 1'!AT8),

....and in Worksheet 3, Cell AT8, I have:

=IF(AS8="win",1 +'Week 2'!AT8,'Week 2'!AT8)

and so on, and so on, and so on!!!!@

Basically, the formula accumulates all the "WINS" in cell AS8 as we work our
way towards the last worksheet.

Instead of copying and pasting from Worksheet 2 to Worksheet 3, the above
formula...then CHANGING the 'Week 2(??)'! reference, etc., etc.,

Is there a way to somehow input:

'Week (n+1)'! or whatever,
thereby avoiding the necessity (obviating) to change the "Week #" reference???

Thanks,

FLKulchar