vba to replace old value by target value search almost key words matching (1 Viewer)

Dear experts

I have data in column D Header value is Source:

I have to align the values proper format like My target is CSV File But it has like CSV or CSV_File or CSV File so it got mis appropriate values of text in col
My target is CSV File from where find CSV
2nd target is Manual - CBT from where ever find CBT change as Manual - CBT
3rd target is Web Adi from where ever find Web or Adi or Web_Adi,wEb adi like
In 3rd condition main criteria is Web Adi MC_MT should not be change it should be as it is

Pls do needful find the attachment

I note you have yet to receive reply to your question. I didn't reply earlier because I didn't understand the question, maybe this is the same for others. I would suggest you add some details and a better explanation of your problem.

Hi sir

i want replace values in A:A column by search keywords from list of names I2:I7.