Macro to sort and insert rows HELP

Thanks for quick response and it does what I asked for but I wish to paste it back in Paste Special Text
I have included another attachment to try to explain what I am trying to do
If you click on HS 1 copy data from web pages

http://www.racingpost.com/horses/hor...abs=horse_form

and use the red macro to paste in column L the macro is

Please Login or Register  to view this content.

This works OK but if possible I wish to use it with the Paste all function from the clipboard for
I tried to copy the result from your macro but can't paste as Text and values for formula on sheet HS won't recognize imported data
Thanks again
Steve

Just to say a BIG thank you watersev for your help .What I did is use your formula which I have adjusted as follows.

Please Login or Register  to view this content.

Then I use

Please Login or Register  to view this content.

AND THEN USE

Please Login or Register  to view this content.

This will clean the two sheets "H" and "B" so I can use those sheets again and again

The only thing I would wish to achieve is instead of selecting sheet "H" to use the Paste all Clipboard button in Excel 2007
I would like to perform that task by using a macro
as said above I manually have too click on sheet "H" cell A1 and press the Paste all Clipboard button
So if a macro is possible I could combine the macros together to save time and not have to switch between sheets.
This is a very long CHRISTMAS LIST but also a macro for deleting the clipboard may come in handy.
Just to repeat
A VERY MERRY CHRISTMAS TO ALL ON THIS SITE
ESPECIALLY YOU "WATERSEV"
AND HAPPY NEW YEAR
Many THANKS
Steve.

Hi Steve and a Merry Christmas to you also.

Please notice code tags have been added for you, but please do this in the future as it makes the thread easier to follow...Thanks.

I would like to perform that task by using a macro
as said above I manually have too click on sheet "H" cell A1 and press the Paste all Clipboard button
So if a macro is possible I could combine the macros together to save time and not have to switch between sheets.
This is a very long CHRISTMAS LIST but also a macro for deleting the clipboard may come in handy.

Thanks again for your reply but using

3. Press CTR L+v while Excel being active application
control
only pastes the last copied item

My excel book has many sheets see attached file.
If I was looking at sheet "CHASE"
I would like a macro that would connect to excel and tell excel to paste all the data on the clipboard to sheet "H" cell A1 but doing that operation while the "CHASE" sheet is activated (I am viewing "CHASE" sheet)
I don't know if this is possible??
As said previously I have to change sheet to sheet "H" cell A1 then press paste ALL using clipboard function button.
The macro would save me from changing sheets.
Thanks again
Steve