OK.. this might be hard, but here it goes..

I have three sheets: 1. with pricing information, 2. With an input section
(how many units and what not are placed into the respective cells) and 3. The
output.

On the first page, 5 different types of models are listed. Under each model
are pricing levels for each additional component added on to the base model
price. Each base model(the 5 different ones) have different pricing levels,
rendering there formulas to be similar and not similar at times.

I have created a drop down menu with each of the five models listed. Under
the menu is a database setup to calculate the price*the quanity of the
various components (i.e. base model, additional seats, service worker
fee,..etc.)

I am trying to have it so that each time I choose one of the models, the
pricing formulas below coordinate with the second page to create each total
price respectively, in each cell..therefore showing the choosen model (with
all the pricing information alone on the third page.

example:

Base model 1.

base fee= 1500 (because 1 model is requested, and they are 1500 per 1)
challenege price: 200...

and so forth.

I can get the formulas to work properly if I list each model at the same
time (in other words, all five models are listed in five separate columns)

I am trying to get it so that if someone choose one of the models on the
first or second page, it will be displayed by itself on the third.

Any help?