I have 4 dynamic ranges setup in my workbook. I would like to be able to do
the following:

When i activate certain cells on another sheet (a1,d1 or g1) i am presented
with an option to select one of the four named ranges. When a selection is
made, the cells are filled down from the activecell with the values
associated with the chosen range.

All assistance greatly appreciated.