making specific dates in VBA generic so it can be applied continuously

[Enzo_Matrix]

I am creating an on-time delivery report and this is the code for one of the steps in my process

Sub NewDay()'
' NewDay Macro
' Button that initiates new day set up for on-time delivery reports
'
' Keyboard Shortcut: Ctrl+Shift+A
'
    Sheets("Feb 23, 2018").Select
    Sheets("Feb 23, 2018").Copy Before:=Sheets(4)
    Sheets("Feb 23, 2018 (2)").Select
    Sheets("Feb 23, 2018 (2)").Name = "Feb 24, 2018"
    Sheets("Feb 23, 2018").Select
    Range("B2").Select
End Sub

I am wondering if there is a way to make the dates in this code change automatically for today's current date
Would changing

Sheets("Feb 23, 2018 (2)").Name = "Feb 24, 2018"
' to Sheets("Feb 23, 2018 (2)").Name = Today()

achieve my goal of having the name of the sheets change on their own to the next day in the sequence?

 

[Enzo_Matrix]

If I hide Feb 23, 2018 so that Feb 24, 2018 is the active sheet, it still populates the same way but now sheets are hidden and still sequence:
Feb 23, 2018 (2)
Feb 23, 2018 (3)....

If Feb 24, 2018 is now the active sheet would it not transition the the 25th? and then 26th? How can I make it transition in this manner?

 

[Fluff]

No. It simply copies today's sheet & renames it with tomorrows date, as that is what your original code was doing.
If that is not what you're after, you'll need to explain exactly what you are trying to do.