Try this: In each dde link address cell except the first one, simply type in
the formula "=(ref) + 1", where (ref) is a cell reference to the previous
address. Now each cell with this formula will always be one greater than the
last one. You can just copy the formula into every cell you need.