Customer list

Hi,
I need help with a customer list I want to create. It should be capable of the following functions:

- A list of customers: Rows for First name, last name, phone number and company name. all that in a seperate sheet

- in the first sheet it should be possible to search for customers in the list, by selecting a customer last name from a dropdown list. in addition it would be nice to choose between a search by last name or by company name.

- the search result should be the same format as the complete customer list, but show only the customer you searched for.

I searched the internet for templates and found something that can almost do anything I want to have, but not compleately (please see attachment).

Thanks in advance for your help!