I'm sure this will be a Macro:

I have several sheets with a workbook that contain part numbers. If a
part number = X, then place an employee number in the next column directly
beside the part number column.

NOTE: Part numbers vary from column to column throughout the work book.

Thanks for your help!!