Auto populate worksheets

Morning all,

I really hope you can help me with this. I am proficient with the Excel basics but have never used macros or complex formulae.

I have a workbook with six live worksheets and a final sheet that consolidates all the data from the other six worksheets.

I would like the consolidation sheet to automatically be updated when data from the other sheets is changed or if new data is added.

Is this possible, and if so, how easy is it?

Many thanks in advance.

Originally Posted by Olly

It should be easy - either formulae in the consolidation sheet to sum data from the first 6 sheets, or a small loop of code to paste+add values from each of the sheets.

Hard to say what is the best approach, without seeing your workbook and required outcome...

Hi Olly,
Thanks for your response. the spreadsheet is business sensitive so I can't share it, but it holds standard type information such as client names, addresses, various Łamounts in different columns etc.

Each of 6 branches has a separate tab which is in effect a client pipeline. over time the information will be updated and new data added as new clients and/ or prospects are gained.

This information needs to be duplicated on a consolidated sheet for management purposes.

Thanks again