Sub consolide_ongletsNomOnglet2()
Sheets("Niveau5").[A2].CurrentRegion.Offset(1, 0).Clear
For Each s In Array("Niveau1", "Niveau2", "Niveau3", "Niveau4")
Nlig = Sheets(s).[U65000].End(xlUp).Row - 1
Ncol = Sheets(s).[A2].CurrentRegion.Columns.Count
[U65000].End(xlUp).Offset(1, Ncol).Resize(Nlig, 1).Value = Sheets(s).Name
[U65000].End(xlUp).Offset(1, -20).Resize(Nlig, Ncol).Value = _
Sheets(s).[A3].Resize(Nlig, Ncol).Value
Next s
End Sub