Collating there an easy way?

Giganews Newsgroups
Subject: Collating there an easy way?
Posted by:  Aardvark (djurmann(at)
Date: Sat, 15 May 2004

Hi all,

In a single workbook I have twelve worksheets, these are values for week 1,
summaries for week 1, graphs for week 1, values for week 2, summaries for
week 2, graphs for week 2, etc up to week 4.  I now want to create 3 sheets
collating the data for all four weeks.  I certainly could use sum, but I
wonder if there is a better way.  The cell references are the same for each
of the sheets I want to collate.