Paste all data in one sheet o f data from multiple sheet

[winmaxservices]

Hi,
Have 2 sheet A, B and in a workbook

All three sheets has data in same with seven columns format as below

Sr. No. (A1)
URL(B1)
Code(C1)
Posted by(D1)
Name(E1)
Date(F1)
Priority(G1).

I want to all data in one sheet (Cumulative sheet). Please refer attachment.

In sheet “A” there are 10 records, in sheet “B” there are 29 records and sheet “C” there are 21 records. So total 60 records.
So there are 60 records in Cumulative sheet.

Please note that attachment is just an example. The data range will be any number of records in original file.

[LeoTaxi]

Maybe this can help

Sub Leo()
For Each Sheet In Sheets
    If Sheet.Name <> "Cumulative sheet" Then
        With Sheets(Sheet.Name)
            .Range("A1").CurrentRegion.Offset(1).Copy Destination:= _
            Sheets("Cumulative sheet").Range("A" & Rows.Count).End(xlUp).Offset(1)
        End With
    End If
Next
End Sub

Kind regards
Leo