you can type a sum reference like this:
=SUM(Sheet1:Sheet3!A1)
Which will add up A1 on all sheets between sheet1 and sheet3.

if you type =sum(, then click the first sheet to apply it to, hold shift and click the last sheet, then click the cells to sum and finally type ), it will give you the same thing.