Can someone help me with macro?

I have data that need to be pulled by weekly with date range. Right now I
have data pulled in pivot table that I go to each pivot table and filter the
dates. Is there a way that I can use macro to pull data, using pivot table,
base on date range? For example, date range from 3/14/2010 to 3/20/2010, and
go to each pivot table and pull data base on these dates.

Big thanks,
ml