I have a chart with named range in Sheet1.

When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is
still linking to Sheet1.

How can I make the source data link to sheet2 automatically. As I have to
replicate sheet1 into 10 different sheets, the automation will help a lot.

Would appreciate advice
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******