excel Scoping names

A named cell or range normally has a workbook-level scope. In other words, you can use the
name in any worksheet in the workbook.
Another option is to create names that have a worksheet-level scope. To create a worksheetlevel name, define the name by preceding it with the worksheet name followed by an exclamation point: for example, Sheet1!Sales. If the name is used on the sheet in which it is designed, you
can omit the sheet qualifier when you reference the name. You can, however, reference a worksheet-level name on a different sheet if you precede the name with the sheet qualifier.