Hi,

I'm thinking you want to create a Dynamic Named Range for the Pivot Table Data. That way you use the Named Range in your Pivot Data Set and it will update. You may also need to press the Pivot Table Refresh to insure they are updated after changing some numbers.

See http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.beyondtechnology.com/geeks007.shtml for DNR.