Locate all occurrances of a value then transfer to 2nd table on another sheet
 

To All,

I have 2 identical size tables on two seperate worksheets.
I need to locate <only ALL occurances of the value "S4" in 1st table
and then transfer to the exact same location within the 2nd table on
the 2nd sheet, without overwriting any other data in the 2nd table.

Any directiontal thoughts?

Jim Pellechi