Hi all!! )

It's very simple.

I have a sheet with 10 charts, each chart has 5 curves inside. Now the goal is duplicate this sheet 20 times, changing only 1 cell on each one of them and so 20 reports for 20 companies will be received. The problem is only with charts, cause it's terribly annoying to change every time references inside the chart. Ranges are same for all sheets but sheet names will vary. I'm sure you're familiar with the problem. Is there the way around??

Thanks in advance!