I have a list of data in each cell. I would like to be able to filter the
spreadsheet based on certain text within the cells. Therefore, in the
example below if I were looking for only Dog or Cat data in column A, I would
use an AutoFilter and use the costum auto filter option and type: contains
Dog or Cat, and only rows that have Dog or Cat in them would appear.
However, what if I would like it to contain 3 different items from the list,
Dog, Cat, and Fish?

Example:
ColumnA
Dog,Cat
Dog,
Mouse,Cat
Mouse,Dog
Fish
Fish,Cat
Fish,Mouse