Getting Macro to dynamically adjust to a new row

Hi there,

I've tried to write a macro that creates a tab for a new room and adds it to the totals. This works the first time I do it, however from the 2nd time onwards it creates a new tab but the totals are still based on data from the first tab I created "Room 2 (2)". I would need this to now be for "Room 2 (3)" instead. How can I make it so the macro accounts for this?

I really don't know much about VBA, I did the macro through the recorder.

Thanks