Refresh data table filters on worksheet activation

I have about 30 data tables on one worksheet that pull data from another worksheet via array formulas.

Now there is possibly 2 very different solutions for what I need, however I will likely address the other in another post.

Each table has been set to 30 rows to allow for new entries to appear on the source data sheet, which will be pulled into the relevant table, however not all the rows are used - sometimes only a single row is populated.

I have set the filters to remove blanks and therefore hiding all the empty row in the tables, each time the worksheet is activated - this makes it much more visually acceptable to the user than thousands of rows of nothing.

A cut of the code I've used is:

Please Login or Register  to view this content.

Is there a cleaner way of doing this by selecting all tables and applying these filter settings?

I live in 'Formula world' usually but I'd expect something like 'for all list.Objects do' or something.

Marvellous - exactly what I was looking for.

Reputation point added - thanks for your help.