Mass changing Named Cells and Ranges

Hi All,

Thank you for all your help previously... It has been a godsend when I am trying to get things completed.

I am currently working on a large real estate modeling solution. It models mixed use developments that include Hotel, Condo, Apartments, retail, commercial components/uses.

I have completed the buildout of one series of worksheets. I have named cells and ranges. I have decided to use a naming convention with the first 2 characters being the use and the the field or range name. For example, apartments are RS, hotel is HO, commercial space is CO, parking is PA, condominium is CD, retail is RT.
I have to create a separate series of worksheets for each use. The series includes development budget and CF, operating CF, massing, summary and returns.

Upon completing one series of worksheets, I was planning on copying the series of worksheets but it result sin a cell/range name duplication and errors.

Is there a better way to achieve the goal of having a complete series of worksheets for each use of the project?

Thanx in advance and Merry Christmas, Happy Holidays

You could use Apps Script to duplicate template files and create file and sheet names using a designated format.