Updated Titles (headings) on a chart
 

Hi,

I have approx 13 sheets. 1 which carries the data and the other 12 sheets
which have charts. Each of the 12 sheets are individually named. My question:
on each one of the 12 sheets i have a chart with a title (heading) which
matches the sheet name. Is it possible that when I update my sheet name i can
get it to automatically update the title. I do know that you can have Cell
references relating to your headings, however my charts are on seperate
sheets and not on spreadsheets.

Any solution will be greatly appreciated.