Executing subs automatically & finding the last row

[spq24]

Hello,

I have a two part question. First: How can I execute a sub automatically. I have about 57 macros in a workbook right now and I need them to be executed in a specific order. How can I do this?

Second: When the subs are executed they put a bunch of data into twelve different worksheets. I want them to bring all this data into one worksheet (lets call that Assemble Sheet). so data from sheet 1 will be copied to assemble sheet and than it brings data from sheet 2 and copies it after the data from sheet 1 in assemble sheet.

This data will grow throughout the year so I need this to be scalable.

thank you!

 

[AlphaFrog]

Sub Run_57_Macros()

    Macro1
    Macro5
    Macro3
    Macro2
    Macro4
    '
    '
    '
    Macro57
    
End Sub

Last used row in a particular sheet

 

[spq24]

My mistake I have 57 subs all named differently and some in different modules than the other