Reverse The Order Of Entry Into The Spreadsheet?

I have a user form and in my code I am using the Erow function

EROW = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

the form works fine and is loading the data to the spreadsheet and inserting it into the first empty row. I need to reverse the order of entry into the spreadsheet. So instead of the data from the form going into the first empty row down the spreadsheet, I need to insert the data in a common fixed row at the top of the sheet, every time and then shift the older data out of the row and down the sheet. Essentially putting the oldest data at the bottom and the newest at the top, which is reverse of the EROW entry process, Last row command would essentially do the same thing and I don't know what command would do what I want.