Hello-
This will be a long entry.

I and currently trying to wrap up a workbook project I've had going on for some time now.
Sheet 1= 'Welding Tracker'
Sheet 2= 'NDE Inspection' *I'm adding these to prevent typing out each sheet name further on*
Sheet 3= 'Radiographic Test'

Sheet 1 -
COL A: This column captures a S/N assigned to each part
COL F: States if part has been "Accepted" or "Rejected" according to the inspection data captured on Sheet 2
COL G: States if a part has been "Accepted" or "Rejected" according to the inspection data captured on Sheet3
Sheet2
COL A: This column captures a S/N assigned to each part
COL E: This column states is the part has been "Accepted" or "Rejected"
Sheet 3
COL A:This column captures a S/N assigned to each part
COL I:This column states is the part has been "Accepted" or "Rejected"

Process: If a part fails it will get circulate back into a rework process, then eventually end up being inspected again, so each sheet has the potential for seeing many multiple data entries. Note: This is a live document that will get updated frequently.

Goal: I want to streamline the data entry process.
Sheet 1 will always be updated first, so, if part #1234 has been Welded (and the information captured on sheet 1), Then when it gets Accepted or Rejected on Sheet2 Column F of Sheet 1 will reflect that
Also Sheet 1 Column G will reflect sheet 3 Column I

Please note, The part numbers in column A do not correlate with rows in each sheet.
I hope I explained that well enough, and I'm looking forward to hearing some (hopefully) solutions
Thank you!