Issue printing Multiple spreadsheets at once

I have a file with 7 separate spreadsheets (tabs) and the 1st and last of which use the 2nd tray of my printer (different color paper). the 5 other tabs print off tray 1.

I can print each individual tab no issue , but when I try to print all tabs at the same time they come out all out of order, and out of the wrong paper source. any ideas?