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!