Is there a way to refresh all pivots in a multi-sheet workbook with several
pivots per sheet situation.

I am updating a list weekly driving many pivots in a work book and I need to
go through and refresh all of them individually. It would be great to
automate this to refresh all at once.