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