Macro To Delete Row As Per Settings

I have a large file of data and the data looks like this repetitively, however, there are also useless data. But I figure out that the repeat data looks the same compare to the useless data. I need to extract the data that I only need. Is there a way to set a macro to search for a String from the beginning of the excel file, when the string is found, it will keep the 2 rows above and 56 row below it, then loop.

Here is an example of it:

A1 USELESS DATA
A2 USELESS DATA
A3 USELESS DATA
A4 USELESS DATA
A5 GOOD DATA

[Code] ....

The macro will start from A1 then go down till find STRING, then will keep 2 row above it which is A5+56 row below it which is A63.

Then continue at A64, then find STRING at A66 and do the same which is copy A64 (2 row above)+till A122 (which is 56 row below), then continue.

Since A123 to A155 does have any STRING, they will all be deleted..