Copy data from one sheet to a master sheet

Hello,
I have a worksheet, sheet1 where I enter the product code and it gives me the Bill of Materials for this product.

I would now like to copy the entire Bill of Materials and add it to another worksheet sheet2. When I enter a new product code in the first worksheet, sheet1, I would like the new Bill of Materials to be copied to the next available row in sheet2.

Can you please help as I have a long list of product codes for which copy paste scenario takes a long time