If this is in Sheet2, A1:H1
Cat ALBUSSON $SP ALBERTSON $SP ALEXANDRA $SP BLOCK

and you want this extracted from A2 down:
ALBUSSON
Albertson
Alexandra
Block

Put in A2 (the earlier suggested formula in the other branch):

=OFFSET(INDIRECT("Sheet"&INT((ROWS($A$1:A1)-1)/128)+2&"!B1"),,MOD(ROWS($A$1:
A1)-1,128)*2)

Copy down

The formula will work all when copied all the way down as explained in the
other branch of the thread, extracting from (once Sheet2's B1:IV1 is
exhausted): Sheet3's B1:IV1, then from Sheet4's B1:IV1, etc as per your
original post's 2nd part request.

(I'm not sure why you didn't try it earlier or why it didn't work for you if
you did)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----