I have several worksheets in a workbook. Each sheet has a column "Part
Number" (in different locations throughout each sheet).

I also have another column "Employee" (which is a number value).

Here's the task: If a part number is 5400 (for example) make the employee
number column 001. Overall, if part number is X, then employee number
automatically pre-fills with an employee number.

Hope this make sense.