Best way to create a summary page from varrying sheets??

[JamesGoulding85]

Hi All,

I have a workbook (attached) that generates a number of worksheets with lists of values. I want to be able to add a sum() formula to the bottom of each row and then copy those values into a table on the main page. Yes I can do it manually but if I delete a sheet or add some more it messes up the summary page. what is the best approach to do this using VBA??

Any answers or guidance would be much appreciated.

Thank you in advance

Jim