Hmmm ... a little confused here.
You talk about copying and pasting and then give an example of that using the INDIRECT function. But that function is nothing to do with copying and pasting - I'll assume that you don't want to actually copy and paste at all, but just want to set certain cell values equal to other cells values using formulae.
INDIRECT takes as it's required argument a reference to a cell. The cell referenced should itself contain a reference to a cell - it is the value of the cell contained in the second reference that is returned.
So you want a function f (cell_ref) that looks up the cell reference contained in cell_ref to get another reference, and set the cell contained in the second reference equal to a certain value? If so, what value? Certainly not that of the cell you're entering the formula equal to - you'd create a circular reference.
You can certainly copy any cell you like and paste it to the next blank cell in Column B - but how do you want to do this? Excel interface or VBA?
Can you make yourself a tad clearer please?
