Details from 52 worksheets into one master sheet Help please

Giganews Newsgroups
Subject: Details from 52 worksheets into one master sheet Help please
Posted by:  Derek Peters (derek.pete…@btinternet.com)
Date: Tue, 4 May 2004

Hi Gord Dibben has given me this formula to take the details from 52 weekly
sheets and give me a total sheet for the year and it works very well (Thanks
Gord)

If sheets are not named Week1 through Week2, you can insert a dummy sheet to
the right of Totals sheet.  Name it Start.

Add another dummy sheet after last sheet.  Name it End.

Formula in Totals  =Sum(Start:End!G25)

Second method allows you to insert new sheets between Start and End sheets
as
your weeks progress.

Gord Dibben Excel MVP

What I would now like to do is make one sheet and have all the weekly totals
listed so I can look at it and see all the sales ,fuel and so on.

There are about 20 entries per week and I can link from a new sheet back to
Week 1 and get the data I need but do I need to do this 52 times (I E 20
links to week 1 and the same for the other 51 weeks) or can this data be
moved in a better way.

Many thanks for your help with this

Regards
Derek

Replies