How to copy and paste chart to reference new data

I have 50+ sheets with data arranged in the very same template. I have made a chart for sheet 1, and I would like to run use this chart for every sheet in my workbook. I recorded a macros with relative referencing of my process for the chart one sheet 1, however it get this error: "Run-time error '-214702489 (800070057)': The item with the specified name wasn't found." It may be worth noting that these values aren't found in my dataset.

I have also tried copy and pasting the chart, however it pasts with data from the original chart. It won't be practical to go through this process of chart making (data selection takes a bit of time) for upwards of 50 sheets.

Thanks for your help!

__________________________