This isn't a question about the scope of names. It's a question about specifying the cells in a name.
Imagine I've created a name
That gets hard-coded by Excel into
Sheet1!A1+Sheet1!B2. But I don't want those cells to be tied to
I want to use this name on multiple worksheets. If I use this name in Sheet1, I want the name to be equivalent to
Sheet1!A1+Sheet1!B2. But if I use this name in Sheet2, I want it to be equivalent to
Is that possible? If so, how?