Option Explicit
Sub Suivi()
Dim WS As Worksheet
Dim WSBase As Worksheet
Set WSBase = Sheets('SUIVI')
For Each WS In ThisWorkbook.Worksheets
If WS.Name <> WSBase.Name Then
With WSBase.Range('A65536').End(xlUp)
.Offset(1, 0) = WS.Range('C6')
.Offset(1, 1) = WS.Range('A13')
.Offset(1, 2).Hyperlinks.Add Anchor:=.Offset(1, 2), _
Address:='', _
SubAddress:=''' & WS.Name & ''!A1', _
TextToDisplay:=WS.Name
End With
End If
Next