Thanks for all of your help with VBA. I have yet another question:

Currently, I've been copying data from a pre-defined sheet number in
multiple workbooks. I'd like to be able to identify the worksheet name to
be copied from. I have this:

Set sourceRange = mybook.Worksheets(SheetNumber).Range("A25:IV45")

And want to put the worksheet name in instead. Suggestions?

Also, if there is no such sheet name in the workbook, what should I do to
deal with the errors.

Thanks,
Barb Reinhardt