Hi.
I’m trying to create a series of sheets in excel. Each sheet is on a different tab. The first tab is a summary of all the other tabs. As I add sheets/tabs the summary needs to update with a new row, summarising some data from the new tab. What’s the best way to achieve this?

Ideally they might be a macro button, which creates a new tab based on a template or something (or copies a existing master tab with fields??), the macro would also need to add a new row to the summary sheet which would then update once data has been fed into the new sheet?

I could of course copy a “blank” template tab each time I need a new sheet, but then I’d have to manually add/copy a row in the summary sheet and then change the formula to look to the new tab I have created? but his would not really achieve what I want.

I hope this all makes sense? Thanks for your help.