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