Get the VBA code shown in the video here http://www.bluepecantraining.com/automatically-refresh-pivottable-data-source-updated/

PivotTables require a refresh if the underlying data is changed or added to. This video will explain how to automatically refresh your PivotTable using a few lines of VBA code. The solution will work when you change existing data or add new data.
------------------------