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