Create a custom search button and list all

Hello,

I need a project to be done for my workplace. Please see below specifics on how it should work below.

somebody clicks the button - it'll find all cells stating 'resolved'(lets say in column B on all sheets) in the workbook and will list contents from the neighbour cell (column C of all worksheets with resolved in B) into a worksheet(or a specific column in the same worksheet).