Macro to paste and delete

I hope someone can help with a macro that will solve this:
I have copied 7 sets of data from a website. The first data is the main and largest data. This will be pasted first and then the other 6 data sets (each is a table) will be used to increase the length of the table starting from the bottom up and at different rows.

The first will be pasted into cell A1. Then the next (first of the remaining 6) will start from row 220, then the next will start from row 166 and so upwards till the last is pasted.

There is a formula in column P that will check the rows and output an error for incomplete data in the relevant cells or will output either of "N" or "OK" as the case may be. The cells with either "N" or "OK" will now form a block of cells under column P surrounded above and under by those with errors in column P. It is hoped that if there are less than 6 "OK"s in each block of cells in column P, the data in the first"OK" row in that block, is used to populate enough row(s) as to now have 6 rows with OK under column P in that block.

Then the macro will delete any row that still has a blank under column A or has "N" under column P. It will not delete those with errors under column P unless they are blanks under column A.

I hope this is not confusing.
Regards