Getting Macro to dynamically adjust to a new row

Thank you again for your help. I was actually hoping to take the sample you provided and apply it to the full spreadsheet but unfortunately what you've done is beyond me. If it's not too much trouble, are you able to apply what you did to this spreadsheet? Would it be able to update both the "1 Totals" tab and "2 Totals" tab. I've once again made a basic macro "Macro1" that adds one new line to both the "1 Totals" and "2 Totals". I can understand if this request takes up too much of your time and thank you for the help prior.