Textbox values to match value in textbox 1 on a userform

Can anyone help me with a user form coding.

I have a combo box that provides sheet names of a workbook. When select the sheet name the combobox fills my textboxes with data from the selected sheet. However in textbox 1 I have an employee name and my problem is that the data in the other textboxes are not for the specified value in textbox 1. Is there any way or can anyone help me with a vb code that can have the textboxes values match the search value in textbox1?

I've also attached the workbook with the userform.

Below is the code I am using:

Please Login or Register  to view this content.