With data in Data!A2:F
and the search keys A1:F1
in the search box sheet, try this:
=iferror(
filter(
Data!A2:F,
not(
mmult(
sign(not(iferror(search(A1:F1, Data!A2:F), A1:F1 = ""))),
transpose(sign(column(A1:F1)))
)
)
),
"(no matching data)"
)