Updating data using vba - to cells

I have a userform that has the following in – labels surname, name, date, listing, payment method, amount and last visit – then I have a combox for the surname and and payment method the rest are textboses. When you click on the combox surname the rest of the userform is filled with data, the user has to the fill out the following info listing, payment method, amount. I’ve gotten this far, now what I am trying to do is once the submit button is clicked then I need this info to be put into the relevant cells (updating a worksheet) Note that I have another userform that I put together which inputs all the data to the relevant cells. Updating the data sheet – I need to put the date into the row and column for that person and listing – then I have columns with the following headings date-method-amount, spanning over 120 across – so each time you update a person’s records it finds the last row and places that info into the relevant columns. I just hope who ever reads this, makes sense of it…I know what I want, but get frustrated not been able to complete it.

Okay let me try to explain a bit better...I tend to get carried away to the end. I have two worksheets named dashboard and the other patient data, on the dashboard sheet I have two buttons one to capture data and place into the relevant cells a3 surname, b3 name and etc – with formulas to work out DOB and last visit and etc – the second button on the dashboard is called patient visit and once you click on that it brings up a userform with the following – label surname and a combo box next to that (which works) under that I have label name and a text box (name) next to that – that when the surname is pulled down using the combo box the name appears in the name text box – then I have label date and next to that a text box for the date (today) another label with listing (this box needs data to be entered in) Next label named payment method and then a comobox and the options are cash, card & etc – label amount and box where you would need to add an amount to. Then another label named last visit and a box – this one gets its data from the data sheet and last a submit button.
So I need to update / put in a patients visit, I click on the patient visit button and it brings up the following userform (patient visit) using the drop down option I call up a patient and 4 things appear surname, name, date and last visit – I now need to add the following info to the userform listing, payment method (a dropdown menu) and amount – now I need to push the submit button and data that needs to be sent to the patient data (in the relevant row/column should be the following – date, payment method and amount (this info goes across eg: aw the date, ax the method and ay the amount again az date, ba method and bb amount – there is space for 120 enters.) listing and last vist has to also go the the relevant data sheet, however those two will always just be replaced.
I hope I’ve made better sense