Hi

in M1 and copied down,

=INDEX($B$8:$B$1000,ROWS(M$1:M1)*10-10+1)