=OFFSET(PRODUCTS2!$B$1,0,(ROW()-3)*2)

The above which uses "ROW()" is sensitive to the cell you're putting the
formula in, and copying down from (assuming it is the starting cell's
formula)

Maybe try this as the starting cell formula instead, and copy down:
=OFFSET(Products2!$B$1,0,(ROWS($A$1:A1)-1)*2)

The above will extract properly when you copy down, but only until the last,
rightmost cell in Products2!$B$1:IV1 (after copying down 128 rows, you'll
exhaust the range in the sheet and you'll get only #REF!)

If you want it to continue beyond to extract from the next sheet in turn,
i.e. Products3!$B$1:IV1, then from Products4!$B$1:IV1, and so on ...
try this formula instead in the starting cell, and copy down:

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

(Formula is the same as the earlier one, but amended to suit your actual?
sheetnames: Products2, Products3, Products4 instead of the assumed: Sheet2,
Sheet3, Sheet4, etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----