So the first matching row in Sheet1 is 2. Do you then want all the matching entries for ADF45 (this is in cell C2) copied to Sheet2. If so, what happens with Row 3 as the code in cell C3 is again ADF45? This will mean that all the cells with ADF45 will in fact be copied 4 times as there's an overall total of 4 matches?

Perhaps if you could post the desired results in a separate tab it will make things clearer.

Robert