Add numbers from sheets to another vba

[Amor_S]

I have an Excel file with 5 sheets that are in the same range. I need to summaries the amount of items added from row "E" from the 4 sheets in to the 5th sheet row "E". The data to be added to 5th sheet is only added when a button is push on each sheet (1-4).

I hope it makes sense of what I'm trying to achieve and sorry for the pictures. Can't get the XL2BB to work correctly.

 

[iggydarsa]

Assuming the 5th tab called "Summary"

Sub AddToSummary()
    Dim i As Long
    For i = 10 To 15 'Iterates through rows 10 to 15 on column E
        Worksheets("Summary").Range("E" & i).Value = Worksheets("Summary").Range("E" & i).Value + ActiveSheet.Range("E" & i).Value
    Next i
End Sub

 

[Amor_S]

Assuming the 5th tab called "Summary"

Sub AddToSummary()
    Dim i As Long
    For i = 10 To 15 'Iterates through rows 10 to 15 on column E
        Worksheets("Summary").Range("E" & i).Value = Worksheets("Summary").Range("E" & i).Value + ActiveSheet.Range("E" & i).Value
    Next i
End Sub

Thanks a lot for the quick reply it works perfectly