Copying worksheet to another workbook brings extra named ranges with it

Hello everyone. This is difficult to describe, so please let me know if there's something I should elaborate on.

Background:
I have a master workbook containing template worksheets. Users copy the master workbook to multiple folders across the server. They also make multiple copies of the individual template sheets. They copy these sheets within the same workbook (which works fine), and sometimes into another copy of the master workbook (this is where the problems arise).

The master data sheets have named ranges scoped to the workbook so other sheets can reference them.

The template sheets have different named ranges, scoped to the individual sheets to allow for multiple copies of the same sheet. There are also formulas on the template sheets referencing the global named ranges.

My problem:
When copying a template sheet to another workbook, new local copies are created of ALL global named ranges, even those not referenced in formulas. The new names reference the previous file, creating an unwanted external link.

When copying, I used to get a popup asking if I wanted to just use the existing name. Choosing yes would avoid this issue, but I'm no longer receiving the prompt. It simply copies the tab and creates all the new names.

Any suggestions?

I'll try to be more concise.

Workbook has 1 Data sheet and multiple Takeoff sheets. There are multiple copies of this workbook across the server.
Data sheet has named ranges with scope set to workbook
Takeoff sheets have formulas that reference names from Data sheet

When a Takeoff sheet is copied from one workbook to another, it should reference the Data sheet in its new workbook (the names are the same across workbooks). Instead, it creates new names that link back to its old workbook.

How do I prevent this?