To get last number in column C of any worksheet...try:

=Lookup(9.99999999e+307,C:C)

Put that result in the same cell of each sheet, then you can use sum across the sheets..

e.g. =Sum(Sheet1:Sheet10!X1)

Where you have Sheets 1 to 10 summing X1 in each sheet.