Compare two lists and highlight the differences

I'm attempting to put together a spreadsheet to help schedule our shop. My plan is to have a separate tab for each machine, have the user enter the job number under each machine, and use vlookup to auto-populate the job info. My sticking point is that the open order report changes daily as jobs are completed and new ones are added. I'd like to be able to compare the old open order list to the new one. In theory, that should tell me which jobs are gone (completeted) and need to be deleted from the sheet, and which jobs are new and need to be added to the schedule. Does anyone have ideas on the best way to accomplish this?

If you can upload a sample file of what you're looking for, it would be helpful.

I'm just getting started, so I don't have anything I can upload at this point. Basically, we run an open order report every day that has job number, description, quantity, etc. That list changes daily as orders get shipped or entered into the system. I want to use that list as the base data to populate the scheduling portion of the sheet. Right now, someone is manually deleting completed jobs from the schedule and adding new ones. I'm trying to automate this process using the open order report, but don't know the best way to make that happen. I hope that's a little better explanation for what help I'm looking for!

O.K Making some progress. Users can add/delete new jobs using a data input tab. They input job number, process, and machine. That data gets copied to a new tab where vlookup references back to the open order report and automatically fills in the rest of the data. Or, they can enter a completed job number and it gets deleted frm the list.

Now I'd like to take the data from this tab and automatically add/delete it to the appropriate machine schedule within the worksheet. Each process has it's own tab, and each machine has a range within the tab. For example there's a tab named saw, and within the saw tab I have 6 different sections, all with a unique saw/range name. What would be the best way to add/remove the data to/from the ranges within the tab?

Copy of Example.xls

Here's what I have so far. In a perfect world, I would like a macro(s) that would automatically remove the completed jobs from the schedule, and then post the data to the correct machine as the data was entered from the input screen. Any hel/ideas would be much appreciated!