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

Put this in B4:

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

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

Hope this helps.

Pete

On Jan 26, 9:09*am, "Father John" <w...@b.com> wrote:
> 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