Have you considered using the menu Data | Filter? Using a custom
filter on column A, you can filter based on the Product Name
containing a particular characters string.
If you want a macro, use Record New Macro and then edit it to suit
your goal.