I have several pivot tables that are updated daily with new data.

Currently, I have filters for "Creation Date" on each of the tables for each month's data. For example, I have a tab for October 2010, November 2010, etc. and on each tab, the pivot tables are filtered by Creation Date for the dates occurring in each month. Each time I add new data, however, I have to update each pivot table to include the new dates, but still exclude the old dates.

Is there a method for me to avoid having to update the filtered dates each time I add new data?

Many thanks!