How do I import every 5th line from sheet 1 to sheet 2

[MSMOMMALW6]

I have a query running on sheet one. Would like every 5th line from sheet 1 to move to sheet 2. I have tried numerous formulas and it is not working as I thought it should work. Help please!!

[martindwilson]

use index
index($a$2:$a$100,rows($a$:a1 )*5) will return rows 5,10,15......... of that