You have a lot of blank row at the bottom of the table. Column X appears to be empty in those row, but they aren't, the cells appear to have spaces in them. This will cause issues, so those blank rows need to be deleted as I have done in the sample workbook.
There is a 31 character limit for a sheet name. Your values in the x column start with a number and then there are some spaces before the name. I wrote code that will cut off the last characters if needed to fit into the limit, so if you have any sheets with the name cut off it is because of a long name that combined with the spaces after the number have gone over the limit. I don't think there are any in existence because originally I wrote the code without the limit and didn't get any errors.
The first time the code is run it's a little slow because there are no sheets and it has to create all of them. My concern with running the code each time and having it go through all the names checking to see if a sheet exists seems to be a non issue as it does this very fast.
Try out the macro, I have it set to run from control + q.
Here's the code and below that is your sample workbook with the blank rows removed and all the employee sheets deleted so you can see the code adding them all.
Sub NewSheets()
Dim r As Range
Application.ScreenUpdating = False
With Worksheets("Sheet1")
For Each r In .ListObjects("Table_CURRENT_EMPLOYEE_S__SSN").ListColumns("F27").DataBodyRange
If Not r.Value = Empty Then
If Not Evaluate("ISREF('" & r.Value & "'!A1)") Then
Worksheets("template").Copy After:=Worksheets(Sheets.Count)
If Len(r.Value) > 31 Then r.Value = Left(r.Value, 31)
ActiveSheet.Name = r.Value
End If
End If
Next r
End With
Application.Goto Worksheets("Sheet1").Range("A1"), Scroll:=True
Application.ScreenUpdating = True