Copying Totals of separate worksheets to a single Summary Worksheet
 

I wonder if anyone can please help me.

I have a several workbooks containing 50 to 80 worksheets. Each workbook has
a summary worksheet of the numerical totals of each worksheets. Each
worksheet is named with a persons name e.g. SmithC, BlackR, HoffmanD.

I'm having to at the moment to copy the totals of each worksheet to the
summary worksheet, one by one. As you can imagine this takes time.

Is there a quicker way to do this?

Thanks,

Gerry