Automatic amalgamation

I have a document with several worksheets, each one containing data from a specific geographic area. I also have one worksheet that contains all of the data from every other worksheet - a master worksheet representing all of the areas. Currently whenever I update one of the area worksheets I have to manually copy the new information onto the master worksheet. Is there a way for this master worksheet to automatically update every time I add new information into any of the area worksheets?

All you have to do is make reference to the cell on the second sheet that you
wish to collect data for. For example:
if you have data on sheet "Area1" in cell A1 and want it on your master
sheet in a specific cell, click on that cell and type in =Area1!A1

HTH
Tom

"Spreadsheet" wrote:

>
> I have a document with several worksheets, each one containing data from
> a specific geographic area. I also have one worksheet that contains all
> of the data from every other worksheet - a master worksheet
> representing all of the areas. Currently whenever I update one of the
> area worksheets I have to manually copy the new information onto the
> master worksheet. Is there a way for this master worksheet to
> automatically update every time I add new information into any of the
> area worksheets?
>
>
> --
> Spreadsheet
> ------------------------------------------------------------------------
> Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
> View this thread: http://www.excelforum.com/showthread...hreadid=545328
>
>

Tom,

The reason that I did not think that your suggestions would work for my spreadsheet is that I need the master worksheet to be sorted automatically. If I let a cell on the master sheet =Area1!A10, which currently is empty, when I sort the data on the master sheet, the blanks go to the top. Furthermore, when I do enter data into Area1!A10, it remains among the blank cells at the top, whereas I want it to be automatically sorted to its rightful place in the master worksheet. Any suggestions?