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

This is more of an Access thing, than XL one. You need to make outer join queries but matching it to your existing comments is the problem XL doesnt do. Access does.
NOW, if you keep your comments in an access table THEN you could just export results to XL.