Printing Entire Workbook with VBA pages

[Caedmonball19]

Jerry had helped me a lot with this file and it works great until I try and select all tabs and print them together. I do this so I can get the page numbers to coincide correctly. The final 5 pages called Year 1, Year 2...... Year 5 are where the macro is populating the information from the other tabs. Normally the letter sequence works perfect but as soon as I print the entire workbook together it changes the setup of the letters where it may go from A to L and start over from A to D and then A to E. Not sure why this is. Any ideas?

[Caedmonball19]

I'm hoping my last post made sense but still have not figured out how to accomplish this. Only happens when I try to print the entire workbook together.

[Caedmonball19]

What I have figured out so far is that when I print the workbook together for some reason it disregards the formula I have in Column A on my last 5 sheets and prints exactly what the other sheets have as the line item reference. When I print one sheet at a time it does refer to the formula though.

[Caedmonball19]

Okay not sure if anyone was looking into this for me, but it appears that if I right click and select all tabs then print entire workbook it messes up my formulas. however if I just have one tab selected and select print entire workbook its just fine. Is this an excel glitch?