I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated.
VBA Code:
Sub Name_Sheet()
If Range("I14").Value = "" Then
'Do nothing
Else
ActiveSheet.Name = Range("I14").Value
End If
End Sub