Drop Down list with color

Hi, I am new to excel vba and need your help.

My table consist of several lines like the example I attach.

I want to automatically create a drop list or update an already created one when the code (loop? I dont know) finds color Grey . Then pick the name of that cell and create a new item at drop down in order when select it to go to that cell.

Is this possible?

Cheers!