To make this easiest your labels, containing the employee names, and the textboxes, where the user enters data, should be named systematically. That is the first label should be something like LabelEmployee1 and the textbox should be TextBox1. (You have holes in the numbers, and some are out of order.) Then you can have a loop to easily store the data.
I'm not clear on why you showed your sample results on Sheet1 instead of Data, where you said you wanted them. But my understanding is that the results should be written to Data.
Also, you said the employee names are always the same. Is it correct that you want them hard-coded as your UserForm labels, rather than load them from the worksheet? If so how will you ensure that the userform matches the employee list on the worksheet? You only have 12 lines on the userform but 43 employees in the worksheet.
You also have stray line feed characters in your label captions. I tried to clean those up but you'll have to go over them.
I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.
Bookmarks