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