Merging multiple worksheets into one, with ongoing data entry

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

I understand that and have actually done it in the past many times. But
this particular one is a bit different. I'll explain it a little
further. The end "consolidated" sheet will contain the information
necessary for a mail merge, first last names address, etc. The other 10
worksheets are peoples information, stored in the same format, that is
being changed and updated with new rows added daily. What I'm saying is
that any one of those 10 wooksheets could be changed or modified at any
time, how do I keep the consolidated one up-to-date, to reflect these
new rows added and changes on any one of the sheets? By using the
formula "=Sheet1!B4" i would only be able to update from one sheet, i
need to be able to update from 10 different sheets.