Using cells to filter page fields in pivot tables thorughout workbook

[DeltBunyan]

Hello,

I have a series of pivot tables in different worksheets that filter various metrics by date. On my front sheet, I have two cells that reference start date and end date for the chosen period (they are an output from other data validation cells). I'm hoping to find some VBA code that will select all dates between start and end and filter all the pivot tables in other worksheets accordingly. Contextures has code for changing a pivot table that will then change all other pivot tables, and it has code for filtering a specific pivot table on the current worksheet based on start and end dates, but I can't seem to find the combination anywhere. Can someone please help me with this?

I am using Excel 2007, so no slicers please!

Thanks so much for any assistance you can provide!