combining totals on different sheets

I am working on a workbook that currently has 6 sheets in it.
sheets 1-5 have total cells in them and the 6th sheet has a grand total cell.
What formula would I need to use to sum all the total cells into the grand total
cell on the last sheet?

Thanks in advance!!
Ben

assuming the sheets are called sheet1,2,3,4,5
and the total cells on the sheet are all the same cell reference say D2

then on the grand total cell on sheet6
=SUM(Sheet1:Sheet5!D2)

Thanks a lot!!

what if the total cells on sheets 1,2,3,4, & 5 are in different cells say like;

sheet 1 total cell # d4
sheet 2 total cell # e2

and so on...

only way i know would be

=sum(Sheet1!D4,Sheet2!E2)