a simple way to do that is with Data/Form from the menu bar. It has a "new"
button that does what you want, also, just pressing <enter puts the data on
the sheet.

"Micah" wrote:

I am looking to create a cover sheet with data entry cells. I want to then
have a button at the bottom of the sheet which when pressed moves all the
data to the log sheet and automatically inserts one row above the new entry.
That way the next data set I enter does not copy over the last entry. Thus
making a log sheet.