Formulas

Hi Amelie

Thank you for your question

If the data that you are seeking to bring together is laid out identically on the different worksheets, then your best approach is to use the Consolidate Function.

In the worksheet where the totals are to go, click on the top left hand cell of the target range. Then click on data and consolidate

Click inside the reference text box and select the first sheet with data and select the range of cells containing the data to be added and click ADD. Then select the next sheet and repeat the process. The range should now be auatomatically identified. Repeat until all the sheets have been added

Then tick the create links to source data tick box. This will update your total field if one of the individual sheets is changed.

Then click OK to create the summary

If this doesn't work please let me know so we can explore other approaches.

Regards

Stephen