Auto refresh table in other tab based on a filter

[Dani_LobP]

Hello all,

I'd like to know how to have a table be automatically refreshed based on a filter.

The thing is that I have 1 tab, where I paste some data (its a table), and then i have in other tab, another table which is populated taking values of specific columns from first mentioned table. And in this case, one of the columns is filtered with a True status...

So the idea is that if I add new rows in first tab, where data table is, then ideally, the second tab where filter is applied, will be refreshed without having to go manually there, and select again filter TRUE.

Not sure if it makes sense what I say... I tried this code below in the tab (took it from How to automatically reapply auto-filter when data changes in Excel?):

Private Sub Worksheet_Change(ByVal Target As Range)
   Sheets("Sheet3").AutoFilter.ApplyFilter
End Sub

but doesn't seem to be doing what i expect.

Below screenshot of the table where i apply a filter:

To mention that the table above mentioned, each cell is linked to the table in the first tab.

And screenshot of table from first tab where I am adding rows:

Hope it makes sense what i try to explain.

On the meantime what i made is a button with a macro that will just remove/add filter again.. but would be nice to be able to remove button and have that happening automatically if possible.

Thanks in advance!

Regards.