Adding the same cell on multiple sheets together

[Remo Shiva]

Hey

I use excel for my invoices, 1 excel file per year, with multiple sheets
for each invoice. It's time for me to calculate total earnings for the
year and I was wondering if there is a way of taking the total value of
each invoice (it's the exact same cell on each sheet) and adding them up
on another sheet? What would be great is if this final tally sheet can
be at the end and if I need to add anymore invoices before it I can, and
the new invoice total will be added to the final tally sheet.

Thanks very much for any help received

 

[Remo Shiva]

Hey

I use excel for my invoices, 1 excel file per year, with multiple sheets
for each invoice. It's time for me to calculate total earnings for the
year and I was wondering if there is a way of taking the total value of
each invoice (it's the exact same cell on each sheet) and adding them up
on another sheet? What would be great is if this final tally sheet can
be at the end and if I need to add anymore invoices before it I can, and
the new invoice total will be added to the final tally sheet.

Thanks very much for any help received

Sorry for wasting time I have sorted it.

I added a sheet at the beginning called First, 1 at the end called Last
and 1 final sheet after Last called Yearly Earnings then used this
formula: = SUM(First:Last!G62)