Transfering a list of data based on a list selection

I'm trying to create a spreadsheet where the user first selects a product by name in a drop down menu (something I've learned how to do) When the product is selected I want a column of numerical data specific to that product to be transfered from somewhere on the worksheet to a specific area where it can be included in calculations. When a different product is selected, specific data for that product will replace the data of the previous, and so on... I've been trying off and on for a couple days to find out how to make this happen, I'm clearly no guru and would love some help, thanks

SMIPRODUCTTEST.xls

I attached a sample spreadsheet which might make my question more clear. When a name is selected in the yellow list (for instance "FUJITSU12K" I want the column of data specific to that model to be transfered or pasted int G7:G10 where it is then summed in G11. hope that helps, thanks