Dragging irregular cell row sequence down a single column

I'm pulling data from another workbook. The data cells are not sequential, i.e. A1,A2,A3...etc. Rather the cells go down the column in this format:

A10,
A15,
A21,
A26,
A32,
A37,
A43,
A48,
A54

....etc. How can drag that sequence down the column without having to code each individual cell along that sequence? If I drag now, that specific sequence breaks. I need to drag that sequence down almost 2000 cells. Hand-coding will take hours. Help much appreciated. Thanks in advance!

If you had the data in column A of Sheet1 in the same file, then you can use this formula (probably in another sheet):

=INDEX(Sheet1!A:A,5+ROWS($1:1)*5+INT((ROWS($1:1)-1)/2))

What you will need to do is to change Sheet1!A:A above to the full path, filename, sheet name and column reference to suit where your actual data is located, then copy down the formula as far as you need it.

Hope this helps.

Pete

Thank you, AGAIN, kind sir. Worked like a charm. You just saved me 10 hours of life!

Glad to be able to help. Thanks for the rep.

Pete