Correct Macros in Excel Spreadsheet thats causing incorrect pages to export on print -- ON MAC 2011 -- 2

I have an invoice / stock list generator that is coded with a macro that on Windows apparently is working fine and printing the exact of amount of pages from the Worksheet. It's printing 14 pages on Windows. 7 Pages from Sheet 1, and 7 Pages from Sheet 2-8. BUT on my mac system, it's printing 7 Pages from SHEET 1, and then instead of printing Sheets 2-8 like it does on the PC, it's printing additional pages and cells from sheet 1. So page 8 will have a cell from Sheet 1 and thats it. I've spent 2 days trying to fix this spreadsheet so it will print right... I don't want to invest a lot of more time trying things. I think the solution is to move SHeets 2-8 into Sheet 1. They have different amount of columns and thats why previous creators had or said they had trouble doing...