RD

Sorry about that, I didn't re-read the original post which does say down
column A.

Second post goes across row 1.

Sometimes hard to keep up<g


Gord

On Sun, 6 Mar 2005 18:54:56 -0800, "Ragdyer" wrote:

Hey Gord,

OP states *down* Column A!

But you're correct, when referring to the *second* post!
Am I supposed to *completely* read them both?<bg

Anyway, lets have the list of sheet names start in A10, and continue down to
A74.

Enter this formula in A1:

=INDIRECT(OFFSET($A$10,COLUMN(A1)-1,)&"!B1")

And drag across the 65 columns as needed to BM1.
--
HTH,

RD