Say you have a cell that totals a column in one of those 10 sheets, and you
want that total to be reflected in a particular cell in the consolidated
sheet.

Click in the cell of the consolidated sheet and enter an equal sign (=).
Now, navigate to the sheet containing the total you wish to copy, and click
in that total cell and hit <Enter.

You'll see that the consolidated sheet's cell now displays the total.
Any changes to the total on the other sheet will show in the consolidated
sheet.

If you look in the formula bar, you'll see a formula similar to this:

=Sheet1!B4

You can now copy this syntax to your other cells, making the necessary
revisions to display other cells, or you can continue with the same
procedure, and let XL create the formulas (links) for you.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Bear" wrote in message
ups.com...
I have a workbook that has about 10 worksheets and one "consolidated"
worksheet in the back. I was wondering if there is a way to continue
using the 10 worksheets, entering data, and have them automaticaly
continue adding the data entered to the "consolidated" worksheet in the
back of the workbook? All the worksheets are set up the same way.