I want to have a range of cells copied into a new cell range based on a
single cell's input. i.e. when I type "area1" into a cell I need to have a
defined range of cells that relate to "area1" automatically conpied into a a
new range of cells.