Call every nth cell from another sheet

Hi!

I want to call cells J10,J15,J20,.. from Sheet1 to Sheet2 in one ROW.

1st problem is, that I can even call every 5th cell and collect them in 1 column and 2nd problem is to put all this in ROW.

Example
sheet1
J5
J6
J7
J8
J9
J10
J11
J12
J13
J14
J15
J16
J17
J18
J19
J20
...

Now I would like to get this only with copy of formula through the row

J5 J10 J15 J20 ...

Thanks for help
Jan

it doesnt work, but it might be close to solution.

what is this array in "COLUMNS($A$1:A1)*5-4 maybe is problem in this A1 cell, because I do not know what it sould do

Thanks

It works for me.

In what way does it not work for you?

Put that formula in any cell
=INDEX(Sheet1!$J$5:$J$1000,COLUMNS($A$1:A1)*5-4)
It returns the value in J5 of Sheet1.

Drag it accross the row to the right, it returns J10 J15 J20 etc..

Ok it works, I made mistake.

Thanks a lot!!