Pulling data when looking at a specific cell?

I know its possible to make a drop down menu, but is it possible to make it so that when I select something in the drop down menu and type in a value in the box to the left of the drop down menu, it looks up data from another sheet that Auto fills into to other boxes?

I have read about the "LOOKUP" command, but im not sure it does what is want to do.

I have posted a pic that hopefully shows what i mean

Hope someone can help.