Search Worksheets if not found

The code below searches sheets in a workbook and lists what is found on the search page. I need to figure out a way to create a message box if nothing is found and stop the code. When nothing is found it will list cells from the first and last page of the workbook. I have attached a sample workbook for you to review.

Please Login or Register  to view this content.

Test - 11.30.2023.xlsm

Check this:

Please Login or Register  to view this content.

Sorry, but I don't understand this:

When nothing is found it will list cells from the first and last page of the workbook.

Can you show an example?

This is perfect. Thank you very much.