Find phrase and erase all other words

Hello,

I am attempting to write a macro that does the following to the attached file. Does anybody know of a quick way to do this? I am seriously a beginner when it comes to VBE. Just ordered a few books on how to do this.

1. Read column A and name it the same name as the current tab.
2. Read column E and if it sees a specific Group’s name, then throw contact information found on Address Values tab onto row on first tab (I through column O). If it sees a specific Group name that it does not recognize, then move on to the next row without copying information. Repeat this step all the way down until there are no more values in column E.
3. Column U:
a. If it sees text in cell “Case Evaluation” change cell to read “Case Eval Complete”
b. If it sees text in cell “Eligibility” change cell to read “Eligibility Eval Complete”
c. If it sees text in cell “Off-Treatment” change cell to read “Off-Treatment Form”
d. If it sees text in cell “Follow-up 1” change cell to read “Follow-up 1”
e. If it sees text in cell “Follow-up 2” change cell to read “Follow-up 2”
f. If it sees text in cell “Follow-up 3” change cell to read “Follow-up 3”
4. Change data found in column W to currency.

Any help is greatly appreciated.Milestone Help.xlsx