Referencing multiple cells

I am trying to figure out how to reference a number of cells from accessing one drop down menu.

I have a list of products with pricing and logistics. I would like to have the drop down menu in another sheet that will access a specific product and the pricing that goes with it.

I know how to do it if i wanted 100 seperate sheets, but I would really love an all-inclusive page that refreshes with the drop down menu.

I have a copy of the file if that i hope will be helpful with colour coded cell references.

Please help.!
Thanks

Use Vlookup:

e.g. in C8: =VLOOKUP($C$4,whole_sheet,9,FALSE)

where 9 represents the column index number within the whole_sheet range..

change to 11 in formula for C9, and change appropriately in formulas for other cells...

I also noticed that your named range for Graphic_Numbers doesn't include the first cell... A9 in Sheet1... is that correct?