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?