Can I use a list to auto fill sheet tabs?

Kelly-

Hope you're doing well.  Yes, this is possible but you'll need to use VBA:

Sub Test()

Dim Lrow As Integer
Dim intLp As Integer

Lrow = Sheets("MySheetNames").Cells(Rows.Count, "A").End(xlUp).Row

For intLp = 2 To Lrow
    Sheets.Add After:=Sheets(Sheets.Count)
    Sheets(ActiveSheet.Name).Name = Sheets("MySheetNames").Range("A" & intLp)
Next intLp

End Sub