Easiest way is to write some VBA code. Which column (presumably the same on both sheets), and at what point does the gap increase to four rows? Are the sheets actually called WKsheet1 and WKsheet2?
You mention an IF formula - what IF formula? Do you just need to copy the values from one sheet to the other or something more?