Ron,

Actually,
each file contains the inforrmation(chekin information) of every day for a
different location. It holds about 200 max lines per dayx 60 days=8000 lines
max.
I thought next to each spreadsheet create another sheet pivot table as a
daily summary. and then have a macro to collect "all the summary sheet in a
master summary table.

something like
sheet 1: Detailed data like Date, Dept Name
Sheet 2 in the same book Day 1, Total of staff per dept

This file is repeated x 75
then have another workbook that has 1 sheet that has all the sheet 2
information line by line. this will be just the same info but appearing in
one sheet without having to open and refresh 75 different files. LIke a pivot
of pivot

Stratis

"Ron Coderre" wrote:

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