I have a need for a macro to do a simple match of figures in 2 sheets:

The macro should match Amt, REF and RT in sheets 1&2
Where there is match, should write in sheet2 corresponding S/N from
sheet1

Sheet1
S/N Amt REF RT

001 200 w1 john
002 100 e3 Pet
003 400 y7 Yep
004 600 z7 Pet


Sheet2
S/N Amt REF RT

001 400 y7 Yep
002 200 w1 john
003 100 e3 Pet
004 600 z7 Pet


Assumption
The number of row undetermined


Result format: the final result in sheet2 should appear as shown
below.

Sheet2
S/N Amt REF RT S/N(from sheet1)

001 400 y7 Yep 003
002 200 w1 john 001
003 100 e3 Pet 002
004 600 z7 Pet 004