help me to sort the data with v.b.a code

[boddulus]

Hi all a very good morning to you all,

I have an excel sheet where there is tons of data which is dispersed in uneven way. can some one please help me with the code to get the desired result.

Please see the sample sheet attached.

things needed from code:

i want a new sheet with name as "Report analysis" to be created with headers in horizontal as ISIN, Cusip,Sedol,Div/Coupon rate
i want macro should copy the ISIN, cusip,sedol ,Div/Coupon rate and paste it in new sheet
the sheet format will be same as sample security reports sheet i provided
ISIN will be in same row and it always be in 13 digits
Cusip will be in 9 digits
sedol will be in 7 digits
after completing sheet 1 it should go to sheet 2 and leave 2 rows gap in report analysis sheet and again do the same process in sheet2 as sheet 1.
please find the desired sheet as sample of what i want.
thanks for your help in advance..... have a good day..........