Finding a named range based on cell value and copy/paste to same sheet?

Can anyone tell me either by way of a w/s function or VBA how to find a named range and then paste that named range in to another sheet.......i have a worksheet that has a list validated cell when i choose a name out of that list and it appears in B1 i would like the matching named range to be found and pasted in to B4:C21 on the same sheet, i tried a combination of HLookup and Vlookup to no avail and i tried a varation of =INDEX(xx,Match(x,xx)) but that didnt work right either as i was trying to pick each cells data individually but in reality the named range as a whole can be copied and pasted in to the range.

Any ideas?

Regards,

Simon

Hi all, i have managed the copying and pasting of the reference range....i ws trying to be to clever for my own good!, but i have a new problem, when i run the code below Excel goes through hundreds of iterations for the one paste is there any way of only getting it to copy paste once per change in B3?

Regards,
Simon

THE CODE BELOW IS ON THE SCORE CARD SHEET
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Goto Reference:=Range("B3").Value
Selection.Copy
Sheets("score card").Select
Range("A27").Select
ActiveSheet.Paste
End Sub