title: Macro to copy a Named Range from one Worksheet to another
body: <p>I have several Named Ranges that contain constant data in one worksheet.
  I have a target range where one of the Named Ranges will be copied to, on another worksheet.</p>
  
  <p>The Named Range that will be copied is selected based on user input into other cells. 
  I have managed to create the name of the relevant Named Range in a single cell.</p>
  
  <p>What I can't do (as I'm a VBA Noob who thought he could do all this without using VBA!), is create a Macro that reads the relevant cell, and then copies whatever Name Range it reads, into the target range.</p>
  
  <p>Any assistance most humbly and gratefully accepted.</p>