I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,
but the range is constantly growing). How can I set the pivot table to
automatically "get" all the data when it refreshes - not just changes to data
in the range I previously defined? Is this something that can be done, or a
limitation in Excel.

By the way, I'm using Excel 2002.