vba search and move next record and previous record

I have the master data of all clients. I want to create it in Label format. Pfa the sample file.

Something like this? Why a search button the name is a dropdownlist

It now works with the name. You select a name you get the data.
Alternative is write a macro to do what the formulas do when either one of the opther fields is entered to search.

So what you really need is a full macro code to do that?
Any VBA knowledge?
Are you using prior to Excel 2007 version?

So why are you saving the file as an older version (xls?)
I've saved the file in the correct format and changed the macros
The first column of Sheet1 is a dynamic named range named 'NAMES' you can add a new name and it will appear in the Data Validation in Sheet2 B2

Will see if I can change it.
Will require some coding and time.

If you ask these type of thing you should keep in mind that you have to be able to do your own maintenance; I would suggest you start some VBA basics too.

I did it this way.
Search on all other fields would require an extra choice because they occur more than once.
I placed dropdownlists in all fields, select one and the first occurrence is shown, with the arrow you can navigate all from there.