I have a workbook that has a lot of pivot tables in it. I currently have to
manually refresh each on in the standard method of right clicking on the
table and hitting refresh.

Is there a way to create a button that I can hit once and will refresh all
the tables at once?