Selecting source data for multiple pivot tables

Hello all,
Is there a way to make all the pivots update to the new cell range instead of me going in to Options-change source data and updating the range on every pivot?

I am doing some variance analysis and have 16 pivot tables in this workbook, and I wanted to see if there was a more efficient way to save time.

Thanks!

Hi,

Can you please post a sample template of your workbook with enough data in it? You may chose to delete the confidential data in the file, if any.