I have a worksheet that has an array of 55 centers using a drop down
list. Whenever a particular center is clicked from the drop down
list, there are 6 corresponding data pivot tables with corresponding
charts for each. So, whenever a center is selected from the list, all
of this information then changes for that specific center. I didn't
create this originally, but when I select a cell that has information
in it that the graph is using, it has this function in it:

=IF(ISERROR(VLOOKUP($A$1,DataPivot!$C$2:$BR$56,5,F ALSE)),0,(VLOOKUP($A
$1,DataPivot!$C$2:$BR$56,5,FALSE)))

The problem I am having is this...I am creating a new worksheet that
consolidates graphs from multiple worksheets, including this one, for
each center all within 1 workbook. I tried to simply copy/paste each
graph onto the new worksheet. After doing this I realized that the
graphs on the new sheet always mimic whatever centers data is chosen
on the original worksheet. Is there anyway to create a macro or write
some VBA to somehow open the original worksheet and select a center
and then copy all the graphs over? I've tried multiple approaches to
accomplish this but I am basically stuck at a stand still. Any help
would be greatly appreciated!!

Thanks a lot