Please forgive me as I'm rather unfamiliar with Excel jargon. I'm using Excel
2003 and would like some help on how to summarise multiple worksheets onto
one master sheet within the same workbook.

Basically the workbook I'm trying to create will have a separate sheet for
each division of the department where I work, outlining project work for that
division. The data will be purely text. Although the content will vary for
each sheet, the headings will be the same. I would like the information from
each sheet to automatically and continuously be copied over to a master sheet
(ideally Sheet1) so that project work across all divisions can be viewed
altogether on demand.

Ideally, once this has been set up, if the master sheet were to be updated,
the relevant cell on the respective divisional sheet would be updated as
well, and vice versa.


Thanks in advance!