Help with Macro to insert totals in all the sheets of the workbook.

[beautify5]

Hello excel experts,

I have made a macro that creates multiple sheets from the data in the Sheet1 with unique records.

So, all copy pasting and different sheets have been created but I want a total at the below of each sheet. There is total at the end of sheet1(master sheet) but that won't flow by my simple macro. so, can you help with a macro that with insert a total/sum line at the last row of each sheet (the number of sheet changes everytime).

Please let me know if you need additional details. Thanks a lot in advance.

 

[beautify5]

Am I supposed to give additional details? Please let me know if i cam not clear with the above. Thank you.