click onto the cell in D where you want the total from A to show. enter =
and go to the cell on A and click onto the cell with the total. press enter
.............done one.........etc

Regards
Bill K
"mjohnson0321" <mjohnson0321@discussions.microsoft.com> wrote in message
news:6B74EAEE-5D70-4AD4-90DF-55DF9A36D824@microsoft.com...
>I would like to create a workbook of several worksheets that sum different
> things and have one worksheet that displays all of the totals.
>
> I.e: Have Worksheet A, Worksheet B, Worksheet C each calculate totals and
> then have the totals carried over to Worksheet D.
>
> How would I do this?