I have created some named ranges on a worksheet...copied the worksheet and
made 3 more.

Looking at the named ranges in the Define Name options, I see that these
named ranges appear with the Name to the left and the tab name to the right...
In Sheet1 it appears as:
NamedRange1 'Sheet1'

In Sheet2 it appears as:
NamedRange1 'Sheet2'


I am referencing these names on another worksheet as ='Sheet1'!NamedRange1,
or as ='Sheet2'!NamedRange1...and it returns the correct values fine.

Now I need to add several more named ranges to all the tabs. Is there a way
to create this type of Named Range directly, without deleting all the tabs,
adding the named ranges and then duplicating that sheet over and over?