build excel spreadsheet with names, email addresses, and city

I have attached a list of names- there are about 2200 names. Please start a new excel spreadsheet (or see attached) On the first line in Column A – label “First Name” Column B – “Last Name” Column C – “Email” Column D - "City" Take each name on the list and add into the excel spreadsheet. For example – Johnson, Jennie Will go into the excel spread sheet as below- First Name and then Last Name Next find the person’s email address on the following website – Intermountain MLS [login to view URL] click on REALTOR Enter agent’s name – Jennie Johnson – enter Click on Jennie Johnson’s name and her profile with show up. Highlight, copy and paste Jennie’s email address into the excel spreadsheet. Please also add the city they are in. Continue with the next name – Lysi Bishop and so on… If there is not an email address on the Intermountain MLS – delete the name and move on to the next one.