Hi, mjohnson0321;

Select a cell cell on Worksheet D where you want a total from Worksheet A to
appear, type =, switch to Worksheet A, select the cell containing the total
you want, and click the green checkmark in the formula bar. You will be
returned to Worksheet D, which will now hold a formula like ='Worksheet A'!A1
which will repeat the contents of cell A1 in Worksheet A.

Another way: select a cell in Worksheet A that contains a total, copy,
switch to Worksheet D, right-click the cell you want to paste into, choose
Paste Special Paste Link. This will paste a formula like ='Worksheet A'!$A$1
giving the same result only with an absolute cell reference rather than a
relative one.

Regards.
IanRoy.


"mjohnson0321" wrote:

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?