Excel Daily report updates.

i have a daily report that is emailed to me with names and number of transactions for each individual showing a monthly count. i want to add the companies to each of the names.

How do i automate it so that each name that is associated to a company, this information is updated with each daily report?