You could put a formula in the cell you want the sum:

=SUM(Sheet1!A:A)