Update Chart Macro
 

Hi,

I have a workbook that contains a summary sheet (based on a 3d formula)
from which I create 2 charts. Can anyone suggest a macro so my user can
press a button and a macro runs to detect any new worksheets that have been
added, add this new sheet to the 3d formula in the summary sheet and the
associated graphs are updated?

Many thanks