Scrollable List With Filters

Hello,

In one sheet called "General Database" I have my main database, and in a second sheet called "Cockpit" I have created a scrollable list for the information in the General Database sheet.

The scrollable list is working fine with the OFFSET function, but I'm trying to apply the Filter tool in this scrollable list so that I can scroll through only the information filtered. (For example, in the scroll list I have a column "Age" and I'd like to filter this column to show only the age 30).

I'm having a very difficult time trying to get this to work. I can apply the Filter tool in the header of my scrollable list but it is not working properly, it only filters sucessfully the 10 rows that are showing when the scrollbar is still. If I move the scroll bar the filter stops working.

Does anybody have a solution for this? Is it actually possible to combine these two features?

Thank you.