Drop down list selection then fills other fields based criteria

[mcowled]

I am trying to create a 'dashboard' where the user selects from a drop down box the product type (all of the product types correspond to a different worksheet, in the same workbook).

I would then like the other fields on the dashboard to be calculated based on the information on the corresponding product type worksheet?

Is this possible?

 

[Crystalyzer]

It is possible, can you post a sample of the dashboard and two or more product type worksheets?