Create Macros to Regenerate PivotTable and PivotChart when Worksheet is Updated.

[kschwerr]

I am new to the world of macros and am trying to create a macros that will regenerate the PivotTable and PivotChart when a worksheet is added to or changed. The end user is not comfortable going into multiple worksheets and manually doing it, and unfortunately, the worksheet contains drop downs that require a new PivotTable and PivotChart be generated when new data is entered (if the original PivotTable does not include one of the entries from the drop down, the new field will not reflect in a "RefreshAll" solution, which would be the easiest method). Any advice is appreciated.