You just have to reference the sheet and the cell in the sheet. See sample
formula below:

=Sheet1!A1+Sheet2!A1+Sheet3!B1+Sheet4!A1
--
Kevin Backmann


"Harvey" wrote:

I have a file that contains up to 5 sheets, I need to total a cell from each
sheet and enter into a colomn on last sheet. What formula do I use? Is this
possible?