Hi Steve,
I can see what's gone wrong.
The search result turns up with "Create named cell references or ranges
on multiple worksheets" at the top of the list (not the right one) and
"Refer to the same cell or range on multiple sheets" just below it
(this is the one you need).
You have accidentally followed the instructions for setting up a named
range.
Get into the one with the "Refer to the same cell or range on multiple
sheets" heading and see how you go with those instructions.

Good Luck

Ken Johnson