I have been trying to do this with simple formulas, but with no luck. I am not very familiar with VBA, but do write reports in other software. Here's what I am trying to do:

If a cell in column H contains "CALL" I need to copy that row + the following 3 rows to the next worksheet. (Some of the following rows contain merged cells also.)

IE:
If
SHEET1!H30 = "CALL"
then paste
SHEET1!40:43

This seems very simple to me, but I keep running into issues. Please help! I so don't want to be working on this all night. LOL