I am attempting to replace worksheet automatically. Currently I have multiple worksheets with the title "JAN 18", "FEB 18", "MAR 18", etc. I have a userform that initiates prior to the macro being ran. I am able to enter a new year (ie: 2019), however the code continues to display "18" for my form year. It is like the entry into the userform is not working. The script I am using utilizes a case statement to select the desired files with a previous year and replace it with the current year.

```
Sub NewFiscalYear()

Dim ws As Worksheet
Dim PrevYear As Integer
Dim FormYear As Integer

FormYear = Format(Date, "yy")
PrevYear = FormYear - 1

'Disabling Display Alerts
Application.DisplayAlerts = False
Application.ScreenUpdating = False

    'Changing FY Date on Forms
     If FormMonth = "AUG" Then

        For Each ws In Worksheets
            Select Case ws.Name
                Case "JAN " & PrevYear, "FEB " & PrevYear, "MAR " & PrevYear, "APR " & PrevYear, _
                "MAY " & PrevYear, "JUN " & PrevYear, "JUL " & PrevYear, "AUG " & PrevYear, _
                "SEP " & PrevYear, "OCT " & PrevYear, "NOV " & PrevYear, "DEC " & PrevYear
                    ws.Name = "ws.name " & FormYear
            End Select
        Next
    End If

```

I am working on a large report that gathers information from multiple other workbooks. My userform includes a date to enter (FormYear) and a month to choose from via a combo box (FormMonth). Once these are selected, the macro is ran. I have the report working great, however have been running into hiccups with the new FY. 

\*\*\*\*\*My goal is to have users run the report on the first month of the new fiscal year, hopefully without them noticing anything has changed (with the exception of it looking like a brand new worksheet). The tabs indicate the current month that was selected along with the fiscal year that was selected in the userform prior to running the macro. Once the tabs are identified with the new year, I am going to go through and reset all of the forms with blank data. I hope this made things a bit more clear!\*\*\*\*\*

Any tips or tricks would be mostly appreciated!