Using Named Ranges in your work in Excel is a highly recommended Best Practice. A problem may arise when trying to refer a Named Range, however. The solution is mastering the easy-to-use Indirect Function!
Using the Indirect Function, along with Validation, is an easy way to make a truly powerful interactive report.
Full article: Indirectly to the point