NEW sheet Macro

[THKUCOMEAGAIN]

Is there a way to create and new macro that i can link to a button that will create an new sheet copy my format of a previous sheet, then apply that to the new sheet, then change the name of the new sheet to the current date (but the date in the macro has to imput the current date so it would change everyday)

I need to bc its a main part of my spread sheet

 

[John Davis]

Is there a way to create and new macro that i can link to a button that will create an new sheet copy my format of a previous sheet, then apply that to the new sheet, then change the name of the new sheet to the current date (but the date in the macro has to imput the current date so it would change everyday)

I need to bc its a main part of my spread sheet

Probably better ways, but maybe:

Sub THKUCOMEAGAIN()
'
    Sheets("PREVIOUS").Copy Before:=Sheets(1)
    Cells.ClearContents
    Range("A1") = Date
    Range("A1").NumberFormat = "[$-409]d-mmm-yy;@"
    ActiveSheet.Name = Range("A1").Text
    Range("A1").Clear
    
End Sub