If they are small enough, say each the size of a letter-size paper, or
so.........perhaps several of them could be copied and pasted into one
sheet.........you could then use Hyperlinks to "find" them for
reviewing..........

Vaya con Dios,
Chuck, CABG,x3

"Bewildered Jim" wrote in message
...
The report I'm doing (monthly) has to have all of the sheets included.
There
are just under 100 of them in. There are no calculation done from them,
they
are included for reference only to show the raw data collected.

Thanks,
Jim

"CLR" wrote:

Do you really need all 50 at the same time?...........maybe you could
bring
in them in say 10 at a time, process them and flush them, then bring in
the
next batch, etc etc.........

Vaya con Dios,
Chuck, CABGx3

"Bewilderd jim" <Bewilderd wrote in
message
...
Using the record macro function, I can not copy multiple (50+)
worksheets
from other files into one workbook. I have tried two ways. First way
was
copying one sheet a a time until I rec'd a too many fonts error. The
second
way was to select all sheets ina workbook and copy them to another.
With
the
second method I rec'd a macro error. Can anyone be of any help?