Insert/Name/Create creates a range name. These are in the names  collection.

You can look at all range names from the application's collection or narrow the
field by looking at the workbook's or the worksheet's collections.

However, I'm now confused over why you'd want to copy  these names.

Although you can have multiple range names with the same name in a single
workbook (in separate worksheets), they're more than a little hard to use and
essentially negate the benefit of having the names in the first place.

What are you trying to achieve?