How do I automatically drop totals from one worksheet into another

[ladytar]

I have created an Excel workboot that contains 5 worksheets. Four (4)
worksheets have totals for each row. I would like those totals to
automatically drop into corresponding columns/rows in the 5th worksheet. How
can I accomplish this?

Thanks for any help you can give.

 

[Bernard Liengme]

=Sheet1A1 in any cell of Sheet2 will display the value in A1 of Sheet1
If sheet names have spaces in them you need ='October Sales'!A1
best wishes

 

[bill k]

In general excel formula's do not "drop into" they "get from"

So,
On sheet 5
in the cell where you would like to see the result from sheet 4,
enter the = sign
click onto sheet 4 cell and push enter.

You can extend the formula on sheet 5.
Click onto the right hand bottom corner of the cell....
the mouse pointer will have changed to a + sign....
and drag down as far as necessary.

 

[ladytar]

Thanks Bernard....I tried this and got an error....#NAME?
What did I do wrong?

 

[ladytar]

Sorry Bernard....I tried it again...with the ! and it Worked!!!! Thanks a
millian!!

 

[ladytar]

Thanks so much Bill....your information is very helpful.