I have a code that takes date from "A7" and text from "G7" to name sheet. Sometimes however sheet names can be too long. How do I modify below code to get date and only the first letter of each word to form sheet name? So if "A7" is 9/24/23 and "G7" is "Georgia Network Meeting", then sheet name should be "Sep23-GNM".

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A7")) Is Nothing Then

    If Range("A7") = Empty Then
        ActiveSheet.Name = "Event" & ActiveSheet.Index - 1
    Else
        ActiveSheet.Name = Format(Range("A7").Value, ("mmmd")) & "-" & Range("G7")
        End If
End If