Sub NomsFeuilles()
Dim T$(), n%
ReDim T(1 To Sheets.Count)
For n = 1 To Sheets.Count
T(n) = Sheets(n).Name
Next
[A1].Resize(n - 1) = Application.Transpose(T)
End Sub
Dim ws As Worksheet
lign = 2
For Each ws In Worksheets
Cells(lign, 1).Value = ws.Name
lign = lign + 1
Next ws