Copy Data from Within same Workbook

[Father John]

Hi
I have a problem that I just can't seem to solve
I have a multisheet workbook and in each there are a series of results that
are located in the same cell but on different pages.
I want to bring these all onto the first Master Page.
In the first cell on the Master Page (sayB4) I type =SUM(Sheet1!E8), I then
want cell C4 to show =SUM(Sheet2!E8) but it says =SUM(Sheet1!F8) copying the
next cell it believes to be in sequence.
What am I missing??

Many thanks
Stephen

 

[Pete_UK]

Put this in B4:

=INDIRECT("'Sheet"&ROW(A1)&"'!E8")

and then copy down. No need for the SUM function.

Hope this helps.

Pete