Copy from one sheet to another using VBA

[WINS]

Hello I am currently retreivng a list to which I add a sequence number and
from which Max() gives me the last record in the list.

Name Country Code Amount Sno
Mr x MRU M01 10.00 1
Mr y ROD R07 5.00 2
Mr z REU R08 5.00 3
Mr a MAL M11 10.00 4
Total 30.00 5

I need to copy these details to another sheet always starting with the last
line in the list and paste the remaining information in the original order.

I have been trying to use VLooup but it would not work everytime.

Thanking you for your help

 

[Don Guillett]

What does the after look like?

 

[WINS]

It would look like this

Name Country Code Amount Sno
Totals 20.00 1
Mr x MRU M01 10.00 2
Mr y ROD R07 5.00 3
Mr z REU R08 5.00 4
Mr a MAL M11 10.00 5