Can I filter data on multiple pivot tables/charts with filter on source table?

[bradbee]

I have a workbook with multiple worksheets. The first worksheet is linked to a sharepoint list. The other worksheets are pivot tables with a chart. I want to be able to place a filter (date range for ex) on the first worksheet (the table with all the original data) and then have it reflected in the pivot table.

Right now when I put a filter on the table it hides the rows but the pivot tables are still pulling all rows and columns.

Is there any way to do this?

Thanks!