How do I create a running total from all preceeding sheets?

[Tubes2015]

First Post!!

Hi everyone,
I'm pretty new to vba and this is the first workbook where I have had to properly apply it so please bear with me. What I am trying to do is have a running total on my last sheet that will update when a command button is clicked. The issue I have is that I will be adding sheets each day to the workbook so cannot define at which point it would stop. I currently have this, however, it only works on one sheet (the first one) and doesn't allow me to use on the subsequent sheets:

Private Sub CommandButton3_Click()

  Dim WS1_Name As String
    Dim WSLast_Name As String

    WS1_Name = Worksheets("Load").Name
    WSLast_Name = Worksheets(Worksheets.Count).Name

    Worksheets("Collated Data").Range("N4").FormulaR1C1 = "=SUM(" & WS1_Name & ":" & WSLast_Name & "!R[49]C[-12])"
    
End Sub

The first sheet is called Load and my sheets currently go from load, load (1), Load (2) .... to Load (10) with all the collected data so far simplified in a sheet called Collated Data, where I would like my cumulative total to be. I would like to add cell B53 in all the load sheets and put the running total in cell N4 in the Collated Data sheet. Any help would be much appreciated as I'm still trying to get to grips with everything.

Thank you in advance.