Reference between two sheets with constant skipping

[OzBakshi]

Hi

I have data in sheet1 that I want to present in sheet2 and to drag a formula with a constant skip between the cells

for example:
I have data in cell D8 in sheet1 and the other relevant data is in cell D23 in the same sheet. I want to present the data in cell E3 and that in cell E4 and so on.
Sheet2 cell E3= Sheet1 cell D8
Sheet2 cell E4= Sheet1 cell D23
.
.
thank you!!

 

[gaz_chops]

Welcome to the forum.

Try

In sheet 2 E3 enter =Sheet 1 D8

In Sheet 2 E4 enter & drag down
=INDEX(Sheet1!D:D,ROW(A1)*15+8)

 

[FormR]

Welcome to the forum!

Here is another option, entered into E3 and copied down.

=INDEX(Sheet1!$D$8:$D$10000,(ROWS($E$3:E3)-1)*15+1)

 

[OzBakshi]

thank you so much guys.