I have an excel sheet which needs to copy values iteratively.

So for example, on sheet 2 I want to

1. copy value of sheet 1 cell A1 to sheet 2 cell A1
2. print it or send it to a print queue
3. clear the values from sheet 2 cell A1
4. copy value of sheet 1 cell A2 to sheet 2 cell A1 (replace contents)

The above process would be repeated for a number of values that is displayed
within sheet 1 cell A1.

Any ideas how to go about it?