Reversing the order of Auto Updated Rows into a new Sheet

Hi Folks

Old problem, new approach.

In the attached worksheet the Rows in Cols A to F are auto updated from another program.
Each new update pushes the previous rows down one so that the latest update is always showing in row 2.

On another Sheet I want to be able to reverse the order so that the first row updated stays as the first row (row 2) and each subsequent one is displayed under the previous etc.

The info showing in row 4 was the first update brought in so I need it to display in the new sheet as row 2 etc.

I have no control on the way the program brings in and displays the updates.

Can this be done either with code or formula or both?

Cheers
Hammer

Thanks FDibbins, now when the next auto update occurs (there will always be a maximum of 20) those rows I have in the sample sheet will push down one and the new info will be in row 2 and so on until we have 20 rows of updates. I need to work another sheet immediately after each update (while it is still in row 2) so I cannot wait until all the updates are done to reverse the order.
Hope that makes sense.

Just wondering if there is a formula to find the LAST value in a Col and then the SECOND last? etc as this could also solve my problem.

Okay, I think we are humming along nicely
Now before I smother you in kisses and because we are now on the same wave length with this, could you give me a formula to input into H2 in Sheet2 that provides an updating COUNT of the number of rows with data (excluding the heading row) as they are submitted into the sheet. I cannot get the normal COUNTIF etc to work because I am a dummy

LOL
Could you please test that in the worksheet sample you posted before for me, it is not working for moi.
Appreciating your time here

Okay, I managed to crack that last problem so it is all systems go.
Once again many many thanks FDibbins