If the product codes are the same like you said you should just list the product codes in column A. This should return the relevant info.

Column B =iferror(Index('Sheet 1'!B:B,match(A1,'Sheet 1'!A:A,0)),"")
Column C =iferror(Index('Sheet 2'!B:B,match(A1,'Sheet 2'!A:A,0)),"")
Column D =iferror(Index('Sheet 1'!C:C,match(A1,'Sheet 1'!A:A,0)),"")
Column E =iferror(Index('Sheet 2'!C:C,match(A1,'Sheet 2'!A:A,0)),"")