copy mirrored data into the first row that has a blank cell in column A

Hi All

There is a formula to mirror certain data in sheet1 into sheet 2, is there a way to make this mirroed data
get entered into the first row with a blanck cell in column A

the wb it is going into has an auto delete macro in which would delete some rows in sheet1 when a given
date is reaached, which would also delete the coppied data in sheet 2, leaving blank rows.

Or is there a way not to have the copied data delete at all but still allow added info should as service costs to be added



Regards

peter