Hi, Stratis

I put some more thought into your situation and remembered Ron de Bruin's
great website. This link contains various VBA code samples for consolidating
data from multiple ranges, worksheets, etc.

http://www.rondebruin.nl/copy3.htm

That should at least get all of your data into one worksheet.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"stratis" wrote:

I have a number of diffrerent workbooks all of them have the same structure
IN each one of them I create a pivot table where I summarise some results

IN need to get these summary sheet in one sheet for presentation purposes
My basic question is how this presentation sheet will be refresed, paste
link will not work if each one of thepivot table is not refressed