Hi Guy

Try this
http://www.rondebruin.nl/copy2.htm

Delet the sheet and run the macro again to have a sheet that is up to date



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Guy" wrote in message ...
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