Try this:

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


" wrote:

I have one sheet (Sheet1) that contains data. Everey 5th row
in this sheet I want to put a referce to in sheet2.

E.g.

Sheet2.A1 = Sheet1! A1
Sheet2!A2 = Sheet1! A6
Sheet2!A3 = Sheet1! A11
Sheet2!A4 = Sheet1! A16

and so on...

Is there a way I can use Autofill in Sheet2 and return every 5th cell
from the other sheet, sheet1?

Regards
Jan