Add data from a userform to a specific row

I am new to using VBA, and this is the first userform I have ever made. I'm trying to build a database of a lot of data for a clinical research trial.

I have been able to get the userform to add the data to the worksheet. However, the issue I came across is that I cannot fit every entry field onto one userform, so I had to split it into two forms. I added an entry field in the second form to identify the patients as well, so I would be able to match the data from the two forms, but I do not know how to get the data from this form to be added to the same row as the data from the first form. So I guess my question is, is there a way to have the userform add the data into a specific row (ie, a row that already contains a specific entry in a specific cell?)

While I was trying to find an answer to this problem, I came up with an alternative. I was thinking that I could have the two userforms add their data into two separate worksheets, then program a macro to copy this data into one master worksheet. would this be easier? if so, how would i go about doing this?

I really appreciate any help you all can give me!