Auto-totalling from several worksheets/workbooks

Hi Sian

You can achieve this by 'linking' your worksheets/workbooks to your new summary workbook.

This is covered on our Excel Intermediate course that you attended, so if you refer to the 'Linking your Workbook' section of your manual then you will find some information and a step by step guide.

If you prefer watching videos, this Youtube video is also pretty helpful:
https://www.youtube.com/watch?v=CcFWUE954qc

Let us know if you have any more issues or need help with a specific problem with your linking.

Kind Regards,
Sarah
Excel Trainer