I am trying to make a spreadsheet to handle my monthly budgets. I have very little experience in Excel 2011 and I know there are pre-made templates already but what I need is very small in comparison.
I would like to have one file for each year, with 12 sheets within that represent each month. I want to have it keep a running total of YTD income on every month as well as other running totals. Is this possible to have a formula that keeps a running total across a variable number of sheets? I would want to be able to create a new sheet (month) and have it automatically have the previous total populated and update when I input the month's amount.