dropdown list, multiple sheets, automatic fill

Hi,

My level of functions in Excel extends itself to using simple functions as IF, however I do have basic programming skills (Java, Pascal etc) and I know how to make dropdown lists.

Is there an elegant way to have within the one and the same Excel document, have one sheet (sheet 1) with input in column format, on a 2nd sheet (sheet 2) have a dropdown list (composed of the input on the 1st sheet), and when an item is selected from the dropdown list the cells to the left (still on the 2nd sheet) be filled with information based on which item was selected in the dropdown list?

I attached an example that shows what I would like to do.

I did manage to do this but with everything on the same sheet, and I used a very long and ugly string of IF functions. I'd need one IF for each input, so 80+ IF statements.

Any help is appreciated, even if just to get me looking in the right direction.

Tnx

Roybean