Stephen

assuming you had, say, 10 full rows on each sheet, you'd have a total of
1000 rows to print. If you *could* just print them one after the other at,
say, 60 rows per page, that would give you just under 17 pages. If you want
to allow a three row gap between blocks of data, you'd have just under 22
pages. If you could align some of the data side by side, you'd be down to
around 11 pages.

And, if your printer can print double sided then half it again.

So, a lot depends on how much data there is and how you want it presented.

Assuming you have that clear in your head, you could code a macro to page
through all the sheets and copy the *values* to a location on the "print
control" sheet.

Easy in theory

Regards

Trevor


"Stephen POWELL" wrote in message
...
I have about 100 worksheets, each has an identical structure.
The area on each worksheet to be printed is small.
If these areas were moved to co-exist on the same worksheet then the
number
of pages required to print everything would be a fraction of 100. (Moving
these areas onto one worksheet is not an option given other reasons for
structuring the workbook the way it is.)
Can I print all worksheets at once and use fewer than 50 double sided
pages?
Many thanks,
Stephen Powell