Search box and search button help

Hello! I am new to the forum - have lurked around before, but just joined and need help with a macro for a search box. Attached is a sample of my database and an example (pulled from another thread on here) that I wish to copy. I have searched these forums and played with code that others recommended for other people, but have not been successful in adapting them to my needs. Any and all help is appreciated.

In my database I would like a search box with a command button similar to the one in the attached "example database to copy." However, I do not want the search option or the results to be on a separate page. I would simply like them to be displayed on the same page underneath the same headings with all other data removed. Then, when you clear the search box all data returns.

Users need to be able to search the entire database (ie, not limited to one column, but whatever word they search for could come from any column). Results should appear when any "part" of the search is found. Last, this database is updated and added to monthly, and it would be great if the "ranges" covered allowed me to add additional data without messing up the code/search function.

Thank you for any help.

Jason