I need to create a worksheet whose sole purpose is to return the values from every 17th row from another worksheet in the same workbook.

I have spent a few hours trying to research the correct answer and OFFSET comes close but either I'm doing it wrong or it's not what I need.

I want to be able to drag the (every 17th row from sheet 1) formula down about 100 rows.

Assume A1 as starting place. I would prefer a formula answer as opposed to a macro or VBA.

Thanks!