When I copy let's say Sheet1 to Sheet2 using Click-Tab, Ctrl+Drag-and-drop,
all local range names in Sheet1 are also copied and are automatically defined
as local to Sheet2. Thereafter, local range names are independently
maintained in each worksheet.

The scenario is when after the fact I need to define a new range name let's
say NewRangeName for Cell $A$1 in Sheet1, how can I define the same
NewRangeName as local to Sheet2 without having to repeat the copy process
Sheet1 to Sheet2. I tried qualifying NewRangeName by using the sheet name
(=Sheet1!$A$1) but as soon as NewRangeName is defined in Sheet2 as
(=Sheet2!$A$1), the latter takes precedence and becomes unique to Sheet2.

Any advice is greatly appreciated.