Referencing Cells from another Worksheet

Hello all,

I was wondering if anyone could tell me how to reference a subtotal from another worksheet, so that everytime the subtotal changes the amount in the second worksheet changes as well.

Please be advised that referencing the cell that the subtotal computes at will not work, as everytime you add a line the cell changes (and unfortunately removing the dollar signs does not work).

Thanks,

Matt