Outputs will be returned as desired, in 128 consecutive rows per sheet, in
the sheetname sequence as above, i.e.: Sheet2, Sheet3, Sheet4, etc

Just some clarifications: What the above means is that if we put the formula
in say, Sheet2's B3, and then copy down, we'll be extracting the same
returns as having:

In B3: =Sheet2!B1
In B4: =Sheet2!D1
In B5: =Sheet2!F1
....
In B129: =Sheet2!IT1
In B130: =Sheet2!IV1
In B131: =Sheet3!B1 (< auto-transition to Sheet3)
In B132: =Sheet3!D1
....
In B257: =Sheet3!IT1
In B258: =Sheet3!IV1
In B259: =Sheet4!B1 (< auto-transition to Sheet4)
In B260: =Sheet4!D1
and so on ..

Should you get #REF! when you copy down, that probably means either the
sheetname(s) doesn't exist yet, or the actual sheetname(s) doesn't match
with ones evaluated by the INDIRECT (perhaps a stray space in the actual
sheetname ?). The assumed sheetnames a Sheet2, Sheet3, Sheet4, etc (Note
that there's no space between the word "Sheet" and the number. Case is not
important.)

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