It doesn't appear that FINDNEXT would be the choice I should use.

I want one macro that searches all worksheets, and if it finds a part
number of 54789, then put employee number 005 in the column directly
beside the part number. This way when one value is entered, it populates
the entire workbook.

Hope this makes sense.