So I have these workbooks just bursting with worksheets. Many identically formatted worksheets, but differing data in each. I go to sheet #1 and I create a chart that looks all purty and sitch. Then I want to copy that table (in all its formatted glory) to every worksheet, substituting the data in that worksheet into the chart. This requires I select each series and insert the worksheet's name in place of the source worksheet name.

Is there an easier way to do this? It's quite annoying to do it over and over manually, and I feel like I'm missing a simpler solution. I'm using 2010, but a solution in any version would help.