Sql tables to Excel - How to Make Live Dashboard

Hello All, I'm not sure how to ask this so I'll just ask. I am pulling in data from SQL tables for our manufacturing software. I want to use Excel as a "live dashboard" where I can keep track of jobs as they move through the shop. Along with that, I want to add a Comments column to this pulled data so I can keep track of follow-up stuff I'm doing that is NOT included in the manufacturing application. Is there a way to tie these columns together so that I if data pulled from the manufacturing software goes away (ie job closed) the jobs AND my comments go away? If not can I highlight that the job status has changed and then manually delete?

A sample is attached.

thank you in advance

Jill