Update tracker row when case status is offered

Your mortgage case entries fall out of sync when offer outcomes are not recorded, leaving brokers and coordinators without clear next steps. It updates the shared spreadsheet and sends a follow-up email so teams act before the next outreach.