Copying Chart Series formula "formats" to another chart

Hi,

I'm wondering if it's possible to copy series formula "formats" to other charts.

Basically, I have a bunch of worksheets with very similar data plotting unique wellbores and also formations (in relation to the location of the wellbores). I've already plotted all of the wellbores but am adding in the formations now. They're all located in the same location on each individual worksheet -- is there a way to copy the series from one chart to another while automatically changing the source worksheet in the process? This would save me lots of time

Thanks!
Ryan

Edit: I currently have the charts on their own sheets as opposed to objects in the source data sheets -- would changing that around make it any easier?