vba or macro ????

[Excelhurtsmybrain]

i need to make a button that saves the current info onto a new sheet with a specific format then clears data an await new entry e.g.

transaction#**bike type**hir duration**hire charge**indettity verified
-----1----**--cycle--**--half day---**---25t----**true

i also wanted to have a trasacyion number i tried countif but it doesn seem to work for that same button to put a number in a cell everytime it is clicked for like a each transaction to have their own nique number