I have a worksheet with about 50 tabs and each one has the exact same table references. I would like to create a chart in each tab and with each one referencing the respective table in that tab. Is there a simplified/efficient way to do this without having to going to each individual tab to create that chart?

I have tried creating a chart in one worksheet and copying it to multiple worksheets, but excel will not allow me to paste it. I've also tried selecting multiple worksheets silmutaneously and then creating a chart, but that also does not work.

Anyehlp will be greatly appreciated