The issue is I utilize Month, YTD and Full Year tabs for each recipients distribution; in my case they are broken out by name, so for example it would read "John Smith", "John Smith (2)" and "John Smith (3)" less the quotations for MTD, YTD and Full Year respectively.
So... Does that mean the "John Smith" is actually the Full Year report/tab?
"John Smith", "John Smith (MTD)" and "John Smith (YTD)"
Or
"John Smith", "John Smith(MTD)" and "John Smith(YTD)"
Or
"John Smith", "John Smith MTD" and "John Smith YTD"



I soooo much dislike spreadsheet designers that don't use proper patterns. It makes life so complicated.

I'm just gonna a save this here in case I decide to come back to it. 
Option Base 1

Sub SplitReportsIntoNewBooks()
'This assumes that all sheets with the same Client Name are next to each other
'This assumes that there is no spaces(s) between a Client Name and the Open
'   Parentheses around the Report Category
Dim Clientname As String
Dim Category As String
Dim Extension As String
Dim List As Variant
Dim Tmp As Variant
Dim WkSht As Worksheet
Dim ShtName As String
Dim SINW As Long
Dim i As Long

Extension = ".xlsx"
ReDim List(Worksheets.Count, 3)

With Application
   SINW = .SheetsInNewWorkbook
   .SheetsInNewWorkbook = 3
   .EnableEvents = False
   .DisplayAlerts = False
End With

For i = 1 To Worksheets.Count
   Tmp = Split(Worksheets(i).Name, "(") 'Will Error on "John Smith"
   ShtName = Tmp(1)
   Category = Left(Tmp(2), 3)

'Make new book
'Add Sheets i + 1 + 2 increment i
'rename sheets
'Save and close

Next i


With Application
   .SheetsInNewWorkbook = SINW
   .EnableEvents = True
   .DisplayAlerts = True
End With