I have multiple sheets doing the same calculation. Initially one was set up
and copied mutiple times. This created multiple range names with the same
name but within a sheet.

I now want to create an extra name within each of the 10 sheets but if i use
the same name it simply updates every sheet not each individual sheet.