Tom,

Thank you so much for your help! Unfortunately, it's not copying
correctly. Project (1) worksheet data is copying correctly from
Projects.xls to Projects2.xls, but then Project (2) worksheet data is
copying from Projects.xls to the Project worksheet (hidden worksheet
only used for generating new worksheets) in Projects2.xls. However, if
I create the appropriate number of worksheets before running the macro
- so that the worksheets in each are the same - then the macro works.
(The code won't run the macro to create a new project as needed along
the way.)

I'll keep poking around, but at minimum we can tell folks to create the
projects first in the new workbook before copying over the data.
Thank you again!
Tina