You don't need SUM() unless you're actually SUMming. Try:

=Sheet2!A1

(Type "=", then select the source cell).

In article ,
"KP" wrote:

I have multiple sheets. To have data from one sheet shwoing on the other
sheets I am using "=SUM(" and then selecting the sorce cell.
I used the same fomula to have text from one sheet showing on another, but
it brings up only "0". Seems like this formula is not working for text.

To have text showing on different sheets, which formula I should use? Thank
you.