Copy datas same line different rows to other cells

[freejack]

Good morning to everyone,
I hope to be clear enough as English it's not my mother tongue.

Here is my problem:
I'd like to copy data from various cell placed on the same lime but at a, fixed, different row position, without having to tape it manually.

I had a look on the net but between my inexperience and the differences in language (my excel is in localized in Italian), I'm having some rough time figuring it out!

This is what I would like to do:
copy Value from =Sheet1!A:10 - =Sheet1!E:10 - =Sheet1!J:10 - =Sheet1!O:10 (from every 5th row in Sheet1 for couple 100th times)
to Sheet2 A:10 - B:10 - C:10 - D:10 (filling every cell on a fixed line in Sheet2).

Like all newbies i tried writing down manually, couple of times, the cells from which the data should be taken and then i tried to drag hoping it would recognize the pattern: naturally it doesn't work.

If I input the first 2 or 3 (=Sheet1!A:10 in A:10, =Sheet1!E:10 in B:10, =Sheet1!J:10 in C:10) and then drag it goes with the very next one following (=Sheet1!K:10).

Please point me to something that can help me sort this out!
Thanks.

[JBeaucaire]

You can use the INDEX function to bring back the "Nth" position of the indexed values.

In Sheet2 cell A2, enter this starting formula:

=INDEX(Sheet1!10:10, COLUMN(A1)*5-4)

Now copy that cell the right and as the COLUMN(A1)*5-4 adjusts itself to COLUMN(B1)*5-4 the result of that snippet will keep going up by 5 cells at at time.
Copy that formula DOWN and it will adjust to row 11 on sheet1.