Delete rows thar contains specific text and then paste 5 row data to col.

Hi, can any Expert on this forum provide me code for :-

01. DELETE ROWS THAT CONTAINS SPECIFIC TEXT,BLANK ROWS , ROWS WITH "----" & " =======" IN COL."A"

2) NOW EACH RECORD IS OF 5 ROWS. CUT & PASTE DATA OF ROW 1 TO A1, ROW 2 TO B1, ROW 3 TO C1
ROW 4 TO D1, ROW 5 TO E1 ON SHEET2

3) NOW AGAIN REPEAT ABOVE PROCESS FOR SECOND RECORD,AFTER COMPLETING PROCESS REPEAT
THIS PROCESS TILL LASR RECORD IS REACHED.

4) THEN CONCAT A1,B1,C1,D1,E1 (DATA ON SHEET2) TO A1 OF SHEET3

5) PASTE SPECIAL(PASTE VALUES)FOR DATA IN COL."A" FOR SHEET3 TO COL. "A" OF SHEET4

SAMPLE SHEET WITH EXPECTED RESULT IS ATTACHED.

Thanks for guidance.
I am not getting desired solution to my problem. I think I have made question bit complicated. Let's make it simple.
Line below each record is "------------------------------------" is record separator. code should search this record separator
and wherever this record separator is found count the rows between "------" and paste it in sheet 2 side by side(transpose)
i.e. PASTE DATA OF ROW 1 TO A1, ROW 2 TO B1, ROW 3 TO C1ROW 4 TO D1, ROW 5 TO E1 ON SHEET2. and then again repeat this process for second record and so on.
Hoe above explanation will help you in providing solution.