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?