Alright so that seems like a good method but here is something else i hadn't
thought about. What if I used an external data connection? Each pivot table
is then based on that data connection to the source worksheet and refreshes
automatically (without code) upon opening?