Thanks.. that helps me understnad a little more about the formula I'm using.

I can now get the fill series to run down, but I can't get it to run
across.. I only need 4 fills down for each of the 120 pages, yet over 60
across and I've fiddled with the formula a fair bit yet do'nt quite
understand what I'm supposed to change.

I'd hoped that once I was given a push in the right direction( so to speak)
I could fathom the rest out.. to no avail.

I've been using =OFFSET(Sheet2!$A$1,0,ROW(A1)-1)

If someone could help I'd be grateful.

Ta