How to capture new data automatically when using the Filter function

[KRE]

I'm using the filter function that references a data set. The data set gets 10 to 15 new lines added in each week. How can my filter function auto pick up this data?

=FILTER(Tracker!B1104:G1480,Tracker!A1104:A1480='Individual 2024'!A3)

The data set is in the tracker tab and I just added 20 rows to the tracker tab. So I would want my filter function to auto pick up G1500 instead of stuck on G1480?

 

[Fluff]

How about

=FILTER(Tracker!B1104:G3000,Tracker!A1104:A3000='Individual 2024'!A3)

 

[KRE]

yes that will work. I guess I could have picked 1,000,000 as my end number even.

 

[Fluff]

You're welcome & thanks for the feedback.