Good afternoon all! This is my first post so am hoping it will get some attention and a solution.
To keep it as simple as possible my spreadsheet has two sheets to it. Sheet2 contains a list of items, along with product codes, descriptions and costs, Sheet1 is my main page which I will be collating all of the correct items on to do further calculations on later.

sheet2 as shown below:

Sheet1.png

Which is a stock list of items, which for now will remain as is and not be updated.

Sheet1 Row A has the same headers as sheet 2. Column A has a validated data list taking the product code from sheet2 as shown:

Sheet2.png

My question is: If I select a product code into cell A2 on sheet1 from the drop down list, is there a formula that would automatically insert the associated data from sheet2 cells B2,C2,D2 into cells B2,C2,D2 on Sheet1? As shown:

Sheet1 ideal.png

Many Thanks in advance for any input you may give.
Alan