If the problem is that the new data doesn't appear in the pivot table,
you could base the pivot table on a dynamic range, as described he

http://www.contextures.com/xlPivot01.html

Dave Schreffler wrote:
I create pivot tables in a time tracking worksheet I use each month. However,
when I go back to a saved worksheet and enter new data, I can't refresh the
pivot tables. Therefore, I have to re-build the pivot tables in each
employee's worksheet at the end of each month.

What am I doing wrong? :)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com