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