Issue printing Multiple spreadsheets at once

G'day mate, I thought i was the only one with similar issue to yours.  It was annoying aye. 

Issue with my file was that i have 19 separate tabs/sheets and when I'd print mine it would print 11-1 in order and then print 19 to 12.  So id have to swap half pile from front to Back.

I couldn't create the workbook again because i had mix of raw data and Pictures in them.  Copying the contents from current file into another wouldn't copy the formats of pictures.    

I tried everything i found online as well and couldn't fix it, in the end what i did was copied my spreadsheets that were printing in wrong order and then deleted the originals.   

So i copied sheet 19 Infront of 11  then deleted original sheet 19.  Then 18 Infront of 11 and deleted original 18. 

In the end i copied 11 Infront of  11 and deleted original from them end. 

Saved changes and tried to print and it printed in correct order. 

I hope this works for you.

Regarding the wrong paper source  - Maybe when you copy of the spreadsheet try checking/changing the printing options and see if they take effect.

I hope this works for you as well.

Thanks for posting your issue.  All the best.