Hi,
I would use a helper column and formulas. Try this, select column A and insert a new column, column A will now become column B. In the new column type this formula:
=IF(B1>"",B1&COUNTIF($B$1:B1,B1),"")....copy down and Hide column
now select your A sheet, in column A type:
=IF(COUNTIF(Sheet1!$A$1:$A$25,"A"&ROW(1:1))=1,"A","").....copy down
in column B type:
=IF(A1>"",VLOOKUP(A1&ROW(1:1),Sheet1!$A$1:$C$25,3,0),"")....copy down
repeat for your B and C sheet replacing the "A" with "B" and "C".

HTH
JG