Drag/Fill column while skipping multiple reference rows in another worksheet

My reference data is in another worksheet (I'll call it Sheet2) and occurs evey eighth row in the same column (e.g. N30, N38, N46, etc). I want to write a formula in my current worksheet (Sheet1) where I can then drag/fill it down the column and each row (A1,A2,A3,....) will reference every eighth row in my reference worksheet (Sheet2). I've read some similar posts about using INDIRECT, OFFSET, etc but I can't seem to get it to work. It seems like this shouldn't be so difficult. Very frustrated so hopefully someone can help me out here. Thanks

Worked like a charm. Much appreciated.