Hi Hennie

Start here
http://www.rondebruin.nl/copy2.htm


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



"Hennie" wrote in message
...

I'm using a workbook containing a worksheet for each month of the year.
I want to consolidate all the data from the different worksheets into
one worksheet to enable data manipulation by means of a pivot table.
Updates in the individual worksheets must be automatically updated in
the consolidated worksheet.


--
Hennie
------------------------------------------------------------------------
Hennie's Profile: http://www.excelforum.com/member.php...nfo&userid=399
View this thread: http://www.excelforum.com/showthread...hreadid=564063