Compare Serial Number And Copy Data Range

I need to compare a S/n from a huge amount of datarows in sheet 1 with the s/n in a second worksheet.

If the s/n matches i need to copy the datarow from sheet 1 to sheet 2 next to the data allready existing in sheet 2. This removing the row from sheet 1.

If there is no match found in sheet 2, the row ha's to be copied to sheet 3, this also removing the datarow.

like:

sheet 1:

S/n -- name -- price

sheet 2:

S/n -- place -- stock

if match is found need to become:

S/n -- place -- stock -- S/n -- name -- price

if there is no match found data go to sheet 3.