Try this:

=INDEX(Sheet1!A:A,5*ROWS($1:1)-5)

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tom" wrote in message
...
I have 1000 rows of data and i want to copy or link every 5th row to
another
sheet...
thanks...