Filter by value in string and paste rows into new sheet

[johnkrenkel]

I am trying to sort through a file that comes in a bunch of strings. I am hoping to do the following.

Take a value in the Client sheet (Client name) in A2 and filter the results in the Data sheet (trying to find the client name in the string)

Each record takes up 4 lines so I want to copy those adjacent 4 lines and paste them into the right tab. Delete the original data sheet data and go to the next record and continue until the report has been put into the correct tabs. The tabs will be auto created (I have this done)

The logic should be

Is client A (ClientSheet:A2) in Data Sheet
Yes = Create new tab
Copy the row the record is in plus 3 additional rows
Go to Client Tab
Paste in 1st blank row
Go back to Data Sheet, any other Client a records until no
Go back to ClientSheet and look at Client B

Go through this process until there is no more records in the Data sheet and they are all placed.

Not sure if you can do this via an array and copy multiple 4 row blocks at ones.

Any help will be appreciated.

Thanks