Bonjour mchardy418,
Je te propose ce code VBA :
Option Explicit
Sub Essai()
Worksheets("Sommaire").Select: Application.ScreenUpdating = 0
Dim dlig&, lig&, chn$: dlig = Cells(Rows.Count, 2).End(xlUp).Row
For lig = 2 To dlig
With Cells(lig, 1)
chn = .Offset(, 1) ' chn : nouveau nom de la feuille
If chn <> "" Then
If .Value <> "" Then Worksheets(.Value).Name = chn
End If
End With
Next lig
End Sub
dhany