Macros : Column Of Text To Table

I would like to convert rows of text into a table thats readable.

There is a list of 10,000 rows filled with address information like below all in one column, separated by rows.

The Macros should look for a row that starts with the word "Detective"

It should then delete the word "Detective" from the cell in Column A, and copy that same cell into cell C1.

It should then take the next 4 rows below it, and copy each row to E1, F1, G1, H1 respectively.

It should then go to the next occurance of Detective, and continue this process copying into C2, E2, F2, G2, H2 like mentioned above etc.

After the loop is over, It should look for the word "PO BOX" in Column F, if it does come up, lets say in Row 2, it would cut cells E2:H2 and paste into D2:G2

This is the data all in Column A, each line seperated by rows: ...