Formula needed to create grand totals

[Guest]

I have daily worksheets, which are contained in a monthly workbook. I have
daily numeric totals. On the end of the month worksheet, I need these daily
numbers (totals) to grand totaled. At the start of a new month, I begin this
process all over again with fresh worksheets...so I need to end up with
monthly totals, and ultimately...yearly totals. Every single day must have
its own worksheet, and every month will be a new workbook. What is the
formula to make daily totals cumulate onto the end of the month & year
worksheets?

Mahalo from Hawaii

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

The "Bread-Roll" consolidation method - great for accountants. See how
simple it is to consolidate any combination of your organisation's accounts,
daily or monthly. (No VBA used)