Microsoft Excel allows sheet-level named ranges. See here for an explanation. Google Sheets does have "named ranges" functionality, but I have only figured out how to use it on a workbook-level scope. Is it possible to use sheet-scoped named ranges in Google Sheets?
I would like to be able to have a named range with the same name in multiple sheets within the workbook and refer to them with '*'!MyRange.
Best Answer
Google Sheets does indeed have Sheet-level named ranges internally, and they are almost fully functional. :-)
The challenge is that as of 16/2/16 they can only be created by Copying a Sheet with an existing NamedRange and then Google Sheets create the parallel sheet-level named Ranges (in a similar way that excel does when you copy a worksheet containing Named Ranges).
Unfortunately you cannot create them through the Named Ranges window or corresponding Script function.
However, once you have created the sheet-level named ranges, they perform exactly as you would expect, being local to the page, or you can use the Global (Workbook) version (where a specific sheet does not have an overriding sheet-level range).
I have created a Google Sheet that shows how you can use Sheet-level named-Ranges both in formulas and Google Script. You can see it here.
I have also posted a more detailed answer in Google Forums.