I have a column of cells that import there values from another worksheet with
simple formula;
=sheet2!a1
=sheet2!a2
=sheet2!a3, etc.

The problem is that these cells are 6 rows apart and the reference data on
"sheet 2" is in a column with no spaces. If it were only a couple of entries
i would do it manualy but there are about 4500 of them. i was hoping to use
an "indirect" function but i don't seem to be able to copy the formula and
have the cell reference progress down the list, it copies the same cell
reference into all copied cells.