If I have two tabs in my Excel workbook, one which contains some financial
information for a company and several graphs and the other which which
contains the data the goes into the graphs. If I want to copy these two tabs
several times so that I can have the financial information and graphs for
several different companies in my workbook, is there an easy way to update
the tab that the graphs reference without manually changing the reference in
source data on each individual graph?

Thanks for the help!