Option Explicit
Sub U24_récapituler()
Dim o As Object
With Sheets("Récapitulatif")
.Columns(1).Clear
.Range("a1") = "Récapitulatif"
For Each o In Worksheets
If o.Name <> "Récapitulatif" Then
With Worksheets("Récapitulatif").Range("a" & Rows.Count).End(xlUp)(2)
.Value = o.Range("u24").Value
End With
End If
Next
.Activate
End With
End Sub