Macro to sort clipboard Paste all function

WINDOWS 7 EXCEL 2007
Hello, I would like to make a macro that would convert the data below to (See-Below)

LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £336 77 105 --
Hurdle 9 1 1 0 £1,976 £2,803 97 99 99
Rules Races 13
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 19 0 2 1 £0 £1,795 53 60 48
NHF 2 0 0 1 £0 £300 2 98 --
Hurdle 16 2 1 2 £4,330 £5,972 98 105 99
Rules Races 37
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 9 0 1 2 £0 £1,791 50 62 47
Hurdle 35 4 3 6 £11,282 £18,747 102 109 98
Rules Races 44
LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £95 53 92 --
Hurdle 7 1 0 0 £2,082 £2,365 94 107 97
Rules Races 11 1




TO THIS ONE BELOW

LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £336 77 105 --
Hurdle 9 1 1 0 £1,976 £2,803 97 99 99
Rules Races 13



LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 19 0 2 1 £0 £1,795 53 60 48
NHF 2 0 0 1 £0 £300 2 98 --
Hurdle 16 2 1 2 £4,330 £5,972 98 105 99
Rules Races 37


LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
Flat Turf 9 0 1 2 £0 £1,791 50 62 47
Hurdle 35 4 3 6 £11,282 £18,747 102 109 98
Rules Races 44



LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS EARNINGS BEST TS BEST RPR OR+
NHF 4 0 0 0 £0 £95 53 92 --
Hurdle 7 1 0 0 £2,082 £2,365 94 107 97
Rules Races 11 1

BLANK ROWS TO BE INSERTED ABOVE LIFETIME RECORD SO THAT IT (LIFETIME RECORD)IS 7 ROWS APART
ROW 1,8,15,22,29 ETC
LIFETIME RECORD IS SITUATED IN COLUMN A
ANY SUGGESTIONS
MANY THANKS
STEVE