I have a hypothetical WB that I would like to construct. It will have 30 WS's that will have daily updated downloads. Each WS will have the same format. There will be a summary WS that will contain multiple pivot tables, I may need as may as 30 or more pivot tables, that will use the data on the 30 WS's, as their source. Would a one key stroke 'refresh pivot tables' on the summary WS containing the multiple pivot tables update all the pivot tables at once?
If for practicality I chose to have three summary WS's with ten or more pivot tables a piece on them, could I achieve the same results by refreshing the 3 summary work sheets seperately?