How to Find - Copy and Paste certain Entries Derived from a Web Page|VBA & Macros|Excel Forum|My Online Training Hub

Hello everyone my name is Maurizio, and my problem is this.
On an excel sheet in cell (A3: A30) I insert a series of entries: For example:
( Sun
Sunny
A bit cloudy
Fog
Rain
Snow In High Altitude
Scattered Rain
Very cloudy
) etc...!

While in column (E2) some items are written such as: "kiwi, figs, very Cloudy, Sunny" etc ...!

That said: I would like all the matches found in cell (E2) to be copied into column (C3: C30)

Let me explain: Since in the Cell (E2) of my original work, the original data of the Weather forecast are reported from a web page.

I would like only certain data to be extracted, taken from the list in the column (A3: A30); minus everything else that doesn't interest me.

Therefore, once the verification has been made between the data entered in cell (E2) and those entered in the column (A3: A10)
Such Real data should in turn be entered in the Column Only (C3: C30)
That's all !
There is a way to achieve this; In VBA?
Thanks in advance for all the help you want to give me on this. Greetings from Maurizio