I have created a file with 15 tabs. The layout and formulas are the same on each tab; just the data is diffferent tab-to-tab. I have set up a pie chart and formatted it the way I want on the first tab.

I want to have the same style of pie chart appear on each of the tabs, but when I copy and paste onto one of the other tabs, I get the data from the first tab displayed by the pie. Surely I don't have to edit the data selection on every tab??

I just want each tab's pie to copy what the pie on the first tab is doing.

Will be very grateful for advice on how to avoid this tedious process!