I have attached 2 workbooks. The first, "Consolidate" has a section where monthly totals from other monthly tabs are placed. The second file, "Append" is used to add tabs to "Consolidated" and all the daily detail is located in that workbook as well as the monthly total.
Here's how this works. Place these two files in any folder. Open up the workbook "Consolidated" and click of the command button "Add Year". Enter in "2014". You will then need to append to this workbook all the worksheets from "Append" and ask to enter in a 2 digit number (14 for this year) that will be added to the new appended worksheets for the year. For example Jan becomes Jan 14, Feb becomes Feb 14, and so on.
After the "Consolidated" worksheets has it's new tab I populated under each category, by month, a total from a month. For example, January would only show the totals for the month of Jan and so on.
I'm building a macro for each month to populate the consolidated monthly total by category.
The macros are labeled modUpdateJanuaryFormulas, etc. There has got to be an easier way to do this and that what I'm hoping for.