Use Cell Value to Activate Named Range

Hi. I have several named ranges defined. I was trying to create a macro that would pick up a location a user put in a cell and use that to highlight the named range by putting it in the goto box. When I originally recorded the macro, it took the value of the cell at that time and put that in the code. I've tried all the variations I can think of and can't get it to work. I've corrupted the original macro by trying things so it won't work and I'll have to redo it.

Is there a way to make this work or is there some other way to select the named ranges based on the user input?

The purpose of the whole ordeal is to have the user put in their location and then have the macro paste a list of their store data on a page for data entry. Thanks.