You can use a dynamic range as the pivot table source, and it will
automatically expand as data is added. There are instructions he

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

To refresh the pivot table automatically, you could record a macro as
you refresh it manually. Then add that code to an event procedure, such
as activating the pivot sheet.

STEM726 wrote:
How do I set up a pivot table to automatically transfer the data from one
sheet into the table as it is input?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html