Duplex Printing from spearate worksheets
 

I am trying to set up a macro that collects spreadsheets
from separate worksheets and duplex prints them. I tried
to put them together in the same worksheet and ran into
problems with the lengths and widths of the worksheets are
different, so print area becomes an issue. Is this an
Excel issue or a printer issue. When I send the file to
the printer, it thinks they are separate jobs. Does
anyone have any ideas?