Modify to suit for your first and last ws.

=sum(sheet1:sheet10!a2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AndreaV" wrote in message
...
I have created a workbook to track all my bank deposits, automatic
deposits,
and credit card receipts.

Each worksheet has a cell that contains the total receipts from the
deposit
entry date.

Can I referrence this cell on another worksheet that will total all
worksheet totals to date? In other words, I would have a running deposit
(income) total for the year on one worksheet.