I'm in a situation where I have a variety of charts in different places, i.e. spreadsheets, and I want to make copies of all the charts and have them in one spreadsheet. The catch is, I want the copied charts to update like it's counterpart in one of the other spreadsheets whenever I update that charts data. Basically I want to have copies of all the charts I make, which are scattered about, in one place and have them automatically update when the original is. Does this make sense?

Thanks in advance for any help.