Excel help regarding formulas from sheet to sheet

[Maryts]

[timestamp=1173309904] :-?

I have an excel spreadsheet that has about 30 sheets. I have separate accounts on each sheet but often need to see the running balance of each individual sheet. I would like to take the formula from sheet 2, 3, 4 etc and have it show up in sheet 1. This is what I tried:
I want the total amount on sheet 2 in cell E13 to show up on sheet 1 in cell D1. And whenever I make changes to the totals on sheet 2, cell E13, I would like the new total to automatically show up on sheet 1, cell D1. I went to sheet 1, cell D1 and entered =2!E13 and hit enter and another window popped up browsing my files. I'm totally lost as to how to do this.

Help???

[soybean]

The formula in cell D1 on Sheet1 should be =Sheet2!E13.  One way to enter such formulas is as follows: Click cell D1 on Sheet1 to select it.  Hit the = sign.  Now, click on the Sheet2 tab and then on cell E13 on Sheet2, and then hit Enter.