=OFFSET(Sheet1!$A$8,ROW()-1,)

The amendment looks ok to me.

I presume the above is entered into cell A1 in Sheets 2 - 8, and copied down
to A450 as per suggested steps earlier, with sheets grouped? (The formulas
are sensitive to the cells they are in)

If the starting cell is *not* cell A1 in Sheets 2 - 8,
put instead this slight revision in the starting cell:
=OFFSET(Sheet1!$A$8,ROWS($A$1:A1)-1,)
and then copy down by 450 rows as before,
with sheets grouped

Ensure also that calc mode is set to auto.
Check via clicking:
Tools Options Calc tab Auto OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael Link" wrote in message
...
Thanks for the fast reply!

Actually, the rows in the master sheet that i want to 'carry over" are
A8:A400. (I forgot that I have a number of hidden rows at the top that
don't
figure in what I need to do.)

I've tried modifying the formula you so nicely gave me like this:

=OFFSET(Sheet1!$A$8,ROW()-1,)

But it just returns a zero value. Am I missing something? I'm not familiar
with OFFSET, so I'm not sure how else to modify it, and the discussion of
the
syntax in the help box is kind of confusing.