How to do?maybe try Power Query (Get&Transform)
example:100++ sheet (table) with same format
let
Source = Excel.CurrentWorkbook(),
Expand = Table.ExpandTableColumn(Source, "Content", {"Week 1", "Week 2", "Week 3", "Year", "Month", "Day"}, {"Week 1", "Week 2", "Week 3", "Year", "Month", "Day"}),
Filter = Table.SelectRows(Expand, each not Text.Contains([Name], "Query"))
in
Filter
TQSM, very helpfulhere is an example for few tables
What to do...but very annoying for over 100 tables