Creating multiple searchs of a table with comma separated values

Hello all, I barely know anything about Excel. I certainly do not know the correct language to explain myself so I am going to try my best to explain as clearly as possible what I am trying to achieve.

I have a table with a lot of cells containing comma separated values. It is a lists of flowers and their seasonal availability. I want to be able to select options for my search from a drop down menu and get back any cells containing those values. Right now i am only getting back the results for those containing ONLY that value.
Right now I am creating a search by month. When I select "MAY" I only get back flowers that are only available in May but I also want the flowers that are available in may and also other months.
If possible I would like to have a filter on those results from a drop down list where multiple filters can be selected, eg. "red, rust, orange"
and get back all flowers available in May that are either red, rust or orange.

I have my table page name "Main" and my search pages named "Search".
You will see the dropdown search I have already attempted


=FILTER(Main!A5:Main!H136,(Main!C5:Main!C136)=C3)


Any and all help in appreciated.

PS. my file contain macros so please enable them

Thank you so much! and you got the color search working! thank you!
Seeing how long that formula is makes me feel better for not being able to figure it out.
This worked perfectly

ps. I'm replying for a second time so if two responses appear, tha'ts why. I don't see the other one.

Best,

Remy