If the value of the cell in column AB of Sheet A is a 4, then I want to insert the data above row 18 on sheet B. A 3 would have data inserted above row 14. A 2 would have data inserted above row 10. A 1 would have data inserted above row 7.
The data that gets pasted into the new row on sheet B comes from Sheet A. For instance, if cell AB10 on sheet B equals 3, then cells C10, D10, F10, and J10 on sheet B would get copied and their data would show up in cells B7, C7, D7, and E7 on sheet A.