You don't really need a second sheet for this, you can AUTOFILTER the data right there on sheet1.

Does the word HOLD represent an entire cell contents or is it part of a longer sentence?

If column Z is empty, for instance, you could put this formula in Z2 then copy down to see if HOLD is in E2:O2

=OR(ISNUMBER(SEARCH("HOLD", E2:O2)))

...confirm that formula by pressing CTRL-SHIFT-ENTER to activate the array. Then copy that cell down the column. You now have a series of TRUE/FALSE results.

Do an AUTOFILTER on that column for TRUE and you are now looking at all the rows that fit, the others are hidden.