Need help searching multiple work sheets

I have an excel with 20 work sheets and lots of data. I can do a "FInd" per work sheet but its taking me for ever is there a way with formula or macro that I can do a search on the complete file ALL work sheets.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.