I'm trying to troubleshoot some range name conflicts via trial and error and error is ruling the day.

I'm using a workbook with multiple sheets, all of which use the same range names (for good reason). When I built it I first completed a template sheet (with range names) and simply copied the sheet multiple times and this worked to preserve the range names in each sheet. However, I've been making modifications to the existing sheets, which requires making changes to some of the range names. Every time I add a range name to one sheet, it's removing the ranges with the same name in all the other sheets.

Does anyone have any idea how I might resolve this issue without resorting to starting from scratch?