Show the name of the sheet next to each search result

Hello All,

I have the attached workbook. On the "Results" sheet, pressing one of the 4 buttons at the top left will search the other 2 sheets in the workbook for rows that contain a certain value ("Awaiting Parts", "Awaiting LCMM", "Metal Shop" or "Refinishing Shop") in column O on the other sheets. It works great how it is and displays all results correctly. The only thing that i would like to add to this is to add another column on the "Results" sheet (Column S) that would display the name of the sheet that the result was found in (e.g. Battery Shop or Face 2 Pod).

Any help would be greatly appreciated.

Thanks,
Cedric


Password to unprotect sheets or access vba code is: avso