I am trying to create a searchable directory. Tab 1 is a the search page. Tab 2 holds all data
Idea is to type in a word in the search box (B2) and it searches Column A on Tab 2 and returns all rows with that contain that search word. I have removed phone numbers and some data from the form for privacy sake, but for instance you want to search for the word "tax"....it would give copy the rows from tab 2 and return them on tab 1. I would hide the data tab while this is being used so no one can accidentally erase/change anything.

Any help is appreciated!

FOPS Master Phone List- DATA removed.xlsx