I need Macro for my button to create new line with current date

I need to create a macro on my spreadsheet which creates a new line with the current date in the first columb. I can create a macro to do this but i have to select the row I want to put it on. What I need it to do is create a new line with date in first columb under the last inserted colum simply clicking the macro button.

Any help is greatly appreciated, the macro is for the Aldos Pump Hyd Oil sheet for the moment and attaching it to each other sheet afterwards.

Also would it be possible to create a macro to insert a new line with date under previous line on more than 1 sheet with 1 button.

Spreadsheet attached:

Oil Stock Spreadsheet - Remake in progress.xlsm

Also if anyone has any suggestions as to any improvements I can make to the spreadsheet as I dont normally work with excel.

Thanks in advance.

It is not entirely clear to me what you want. Maybe this:

Sub Add_Date()

Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Date

End Sub

Thats brilliant stnkynts, thanks a lot.