Hi

I have a spreadsheet with multiple tabs with information.
The format has to remain but I want to also be able to see the information on one spreadsheet consolidated to be able to do analysis on the back of it.

how would you build a macro to make sure the consolidated sheet is fully up to date?

Thanks
renix