Building a pivot table that changes based on defined range of raw data

[macattack1]

Hi there again everyone. I hope everyone is having a nice Friday evening. I am running into an issue on excel with building pivot tables given a specified range for two date ranges, two numeric ranges, and five metrics. I built a filter function to filter the raw data given these specific constraints and built pivot tables off of that data. The problem I am running into is that when the ranged data changes, the pivot tables do not change accordingly. When I build a table for the ranged data, the Filter function will not run. My question is, does anyone know if it is possible to have the pivot table change whenever the ranged data changes? If so, how am I able to do that without building a table for the ranged data? Thanks for your help and consideration and have a great rest of your Friday and weekend.