Referencing a cell from previous worksheet in same spreadsheet file...

[Clay McCall]

I am trying to carry over a =sum() value from a cell in one spreadsheet to 
another cell in another sheet in the same spreadsheet file.  The instructions 
in the help section “Referencing a Cell in the Same Document” says that the 
formula is =sheet2.A1,  I have discovered that if you rename the sheets then 
this does not work.  Why can I not reference a sheet by another name?

Thanks for any assist,

R/
Clay McCall