I need an excel expert

I have an excel spreadsheet that uses the (=workday) formula to create a backend schedule for building houses. With it I put in one beginning date and it populates the rest of the dates in sequence for the remaining trades. Each row has a trade (ie paint) with a start date and a complication date. I want to add an email address to each row that corresponds to that trade and have it automatically sent to that trade. I only want the trade on that rom to see it’s date and not the whole spreadsheet. Can you help?