How to invert a list of data with macro?

Lets say.. my data:

1
2
3
4
5

i have a macro which will add a new row of data which becomes:

0
1
2
3
4
5

after which, i wish to invert the data to:

5
4
3
2
1
0

which includes the new added data. As such, formula might not work in this case..