Excel Macro to sequence number fill and finally sum

[Yoyes]

Greetings dear experts
I'm trying to create a macro to fill rows values from 0 to 9 starting at A1 and ending at A10, it also must populate B to E with the same sequence. I know I must use count and for function, and while to increase count value but I'm not being able at all to achieve it

Attached a picture that macro must done
Hope you can help me, I'm desesperate
Regards!

 

[Cubist]

You say generate from 0-9 but your picture shows 0-10. Try this macro that generates 0-10.

Sub GenerateSequences()
    Dim a
    Dim i As Long
    Dim ws As Worksheet
    
    Set ws = ThisWorkbook.Worksheets("Sheet5") 'change sheet name as needed
    ReDim a(1 To 11, 1 To 5)
    
    For i = 1 To 11
        For j = 1 To 5
            a(i, j) = i - 1
        Next j
    Next i
    
    ws.Range("A1").Resize(11, 5).Value = a
End Sub