There are seven sheets to the original work book. Each lists a number of
field service events unique to the sheet (installer). What I want, is to
see all these events on one sheet to help identify conflicts and prioritize
and possibly reschedule or re-assign the events for more efficiency.

This may all be possible by creating one additional sheet for the original
workbook and that's OK too. It's just that I want it all on one sheet. I
realize I can manually copy it everyday and review it but if it can be
automated that would be preferred.

I hope that clarifies my objective.


"Gordon" wrote in message
...
Guy wrote:
|| I have a workbook with multiple sheets. Each sheets has somewhat
|| similar data which I would like to list in one new spreadsheet which
|| will update with any change to any of the other sheets. How can I
|| do this? One thing that confuses me is that each sheet can have a
|| different number of rows at any given day. So my new spreadsheet
|| has to grow or shrink to accommodate the change in the quantity of
|| data.
||
|| Thanks in advance
|| Guy

Aren't you just duplicating the data? What exactly are you trying to
acheive with the new workbook that you can't do with the original?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk