Ok then, this is what I did;
When you first presented the 2nd code write you mentioned it needed to be controlled by an update button. I installed a command button (called “Refresh” on the userform in VBA Design mode), then copied and amended your code to it.
Then I got out of Design mode, went to the wrksht, opened the UserForm, clicked the refresh button and none of the data in the first 7 cells appeared in the UserForm. Alternately, I input data in the first 7 textboxes of the UserForm, (numbered 1 through 7, I double-checked), and then hit refresh. None of the data moved to the wrksht.

Code with descriptions follows then the code as written and installed.
Any ideas why it doesn’t work?

Private Sub CB006_Rfrsh_Click()
[name of the “Refresh” Command Button]

UpDateSheet()
[Kept as is]

For x = 1 To 7
[Keeping it simple by trying only the first 7 textboxes and cells]

Takeoff001.Cells(19, 5).Value = Me("Textbox" & x).Text
[Takeoff001 is the name of the wrksht, 19 is the row number and 5 is the column number of the first cell/textbox data location].

Next x
[Kept as is]

End Sub

Private Sub CB006_Rfrsh_Click()
UpDateSheet()
For x = 1 To 7
Takeoff001.Cells(19, 5).Value = Me("Textbox" & x).Text
Next x

End Sub

Off-Topic - What does "Me" mean?
Also - how does one get to the posting format on this forum so that he can alter the font? I see you did it and it makes it much easier to follow.