How to pull data from 1 sheet to another using drop down lists

Hi everyone!
I have two sheets in excel S1 & S2

S1 holds a list of products with the following headers for each column: Supplies, # of units, price inc vat, supplier

S2 with the following headers:
Supply, cost per unit, qty needed, total cost

I would like to pull data from products listed in s1 to s2 using a drop down list.
for example on sheet 2 I select product 1 from dropdown list, which fills cells with data from s1 corresponding to the item chosen (in this case Supplies & cost per unit) Once these values are in place I will create some formulas to work out the cost of producing certain products with the supplies etc from list 1
Hope I have explained myself well enough! Thanks everyone

Hi

Into B2 (Sheet2) put:

Formula:

Please Login or Register  to view this content.

into D2 (sheet2) put:

Formula:

Please Login or Register  to view this content.

and drag both down as long as needed.