Stratis...

I was thinking that you'd pull the list data from the 75 files into one
large list...
then create one pivot table from that list.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"stratis" wrote:

Thank you ron that very usefull,
However does not answer a basic question . Those pivt tables that I copy the
data in one file change. the macro should refresh all of them while in closed
files before updating the data. I am not sure this is feasible
Stratis

"Ron Coderre" wrote:

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