be able to print an entire workbook instead of just 1 page at a time
I do budgets one year at a time. one month per page/sheet. i'd like to print out an entire year (12 pages) without having to print one page/sheet at a time.
Why not give the option to set and save print area profiles by worksheet so one can generate automated reports?
Kenneth Barber commented
Go to File, Print. Look at the dropdown list directly under the Settings heading. You can change this dropdown to Print Entire Workbook. However, I assume that your file has some sheets that you might not want to print. In that case, use the Print Active Sheets option (default) and make sure that you have the sheets that you want to print selected. To select multiple sheets, hold Ctrl while clicking on the sheet tabs. If your sheets are all in a row, you can select them all faster by clicking the start sheet and then Shift + clicking the end sheet. Be warned though: any change that you make to 1 selected sheet will occur to the rest, so be sure to deselect your sheets after printing and before continuing to work in your file. To deselect sheets, click on a sheet that is not part of the selection or right-click on a sheet in the selection and go Ungroup Sheets. Remember that Print Areas can also aid with printing. They let you specify an area each sheet that can be shrunk to fit to print on 1 page.
However, I don't think that your layout is the best for your needs. If you can rearrange your file to have all months on 1 sheet, then you could take advantage of functions like SUMIFS, which let you sum only the rows/columns that meet certain conditions (e.g. only January, only 2016, only a certain department).
A more powerful summary technique is PivotTables + Slicers. Again, you need all of your raw data on 1 sheet. PivotTables are dynamic summary tables. This way, you only have a single Monthly Summary sheet instead of 1 per month. (Notice that I am making a clear distinction between raw data (manually entered) and summary data (calculated from raw data).) If you want only January or only 2016 or only a certain department, then you can filter the PivotTable to become just that. It supports all sorts of calculations, including SUM. Basically, if you are using the actual SUM function to do your summaries, then you've been doing it the hard way this whole time. The only downside to PivotTables is that your raw data needs to be in a specific format, which I explain in the link below:
A third summary technique that you can use is 3D references, though I wouldn't recommend it over PivotTables; it's just for your knowledge. Basically, if you have sheets January through December, then on an Annual Summary sheet, your formula would look something like SUM('January':'December'!A1) rather than January!A1+February!A1+...+December!A1. This of course requires all of your monthly sheets to have the exact same layout and your monthly sheets to be consecutive.
In summary, you can already print the way that you specified above, but since you are doing calculation-intensive budgeting, I would recommend rearranging your file to use PivotTables, which requires raw data to be isolated and in a specific format but will make your life MUCH easier. If I wasn't clear enough on something, feel free to comment.