As I prepare to link workbooks, I have to type descriptive range names, e.g.:

CDA_GrossSales_Case1

Now, the workbook contains 3 different scenarios, therefore there will also
be named ranges:

CDA_GrossSales_Case2 and
CDA_GrossSales_Case3

There will be several other sets of named ranges and, in each instance, the
name will only differ by that one differentiating number on the end. Both
from the point of view of reducing typos and unnecessary typing, I have been
looking (in vain!) for a way to copy the names from one range to the next, so
that I all would have to do would be to change that one digit. Any
suggestions?