MS Excel / VBA help thread

Cough. it's me. Yes. me.

I have this:

Sub HospitalFilter()
Dim LastRow As Long, LastCol As Integer, i As Long, iStart As Long, iEnd As Long
Dim ws As Worksheet, r As Range, iCol As Integer, t As Date, Prefix As String
Dim sh As Worksheet, Master As String
On Error Resume Next
Set r = Application.InputBox("Click in the column to extract by, i.e. Cell A1", Type:=8)
On Error GoTo 0
If r Is Nothing Then Exit Sub
iCol = r.Column
t = Now
Application.ScreenUpdating = False
With ActiveSheet

Master = .Name
LastRow = .Cells(Rows.Count, "A").End(xlUp).Row
LastCol = .Cells(1, Columns.Count).End(xlToLeft).Column
.Range(.Cells(2, 1), Cells(LastRow, LastCol)).Sort Key1:=Cells(2, iCol), Order1:=xlAscending, _
    Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
iStart = 2
For i = 2 To LastRow
    If .Cells(i, iCol).Value <> .Cells(i + 1, iCol).Value Then
        iEnd = i
        Sheets.Add after:=Sheets(Sheets.Count)
        Set ws = ActiveSheet
        On Error Resume Next
        ws.Name = .Cells(iStart, iCol).Value
        On Error GoTo 0
        ws.Range(Cells(1, 1), Cells(1, LastCol)).Value = .Range(.Cells(1, 1), .Cells(1, LastCol)).Value
        .Range(.Cells(iStart, 1), .Cells(iEnd, LastCol)).Copy Destination:=ws.Range("A2")
         ws.Cells.EntireColumn.AutoFit
         ws.Cells.EntireRow.AutoFit

        iStart = iEnd + 1
    End If
Next i

End With
Application.CutCopyMode = False
Application.ScreenUpdating = True
MsgBox "Completed in " & Format(Now - t, "hh:mm:ss.00"), vbInformation

 Application.ScreenUpdating = True

End Sub

What do I need to it to make it do "now save all the files you've created based on the contents of the cell you selected at the set r= step"?

(the cell i pick will have a 3 letter code. I would like the newly generated worksheets to be split out and saved as ABC data.xlsx)

eta: actually, if it could be ABC data month.xlsx (where month is the month the file was created) that would be bostin