I'm having trouble following your post but the syntax I think you are
looking for is:

=SUM(Sheet1:Sheet2!A1)

In other words:
=SUM(FirstSheet:LastSheet!Range)


--
nbrcrunch