Formula: Drop Down List -> Choose Option Finds Cells & Replace Cells with Cells

So I'm creating an Excel Spreadsheet for work & the concept is very simple.

I need to be able to Choose a Product from the drop down list on Page 1 (Formula) & the option will Select various cells from Page 2 (Data) in the workbook & replace the cells on Page 1 (Formula) with that data From Page 2 (Data).

This is what I have So far:

Excel Spreadsheet, Work in Progress:

http://bombclock.com/excel/Testing.xls

(Right-click, Save As....)
-----------------------------------------------------------------------------------------------------------

So the Formula needs to go something like this:

SORT BY: NAME ASCENDING: Drop Down Menu: -> Opt1 Name = Cell A6 (From Page 2)
Opt2 Name = Cell B6 (From Page 2)
Opt3 Name = Cell C6 (From Page 2)
Opt4 Name = Cell D6 (From Page 2)


Opt1 Selected: Replace Cell B1 (From Page1) w/ Cell A1 (From Page 2)
Replace Cell C1 (From Page1) w/ Cell A6 (From Page 2)
Replace Cell F1 (From Page1) w/ Cell A2 (From Page 2)
Replace Cell F2 (From Page1) w/ Cell A3 (From Page 2)
Replace Cell F3 (From Page1) w/ Cell A4 (From Page 2)
Replace Cell F4 (From Page1) w/ Cell A5 (From Page 2)

Opt2 Selected: Replace Cell B1 (From Page1) w/ Cell B1 (From Page 2)
Replace Cell C1 (From Page1) w/ Cell B6 (From Page 2)
Replace Cell F1 (From Page1) w/ Cell B2 (From Page 2)
Replace Cell F2 (From Page1) w/ Cell B3 (From Page 2)
Replace Cell F3 (From Page1) w/ Cell B4 (From Page 2)
Replace Cell F4 (From Page1) w/ Cell B5 (From Page 2)


Opt3 Selected: Replace Cell B1 (From Page1) w/ Cell C1 (From Page 2)
Replace Cell C1 (From Page1) w/ Cell C6 (From Page 2)
Replace Cell F1 (From Page1) w/ Cell C2 (From Page 2)
Replace Cell F2 (From Page1) w/ Cell C3 (From Page 2)
Replace Cell F3 (From Page1) w/ Cell C4 (From Page 2)
Replace Cell F4 (From Page1) w/ Cell C5 (From Page 2)

And so on......

Any help is apppreciated, I need a combo box vs. list box