VBA Referring to a Cells/Columns

Hello! Is there a way to refer a text box on a User form 4 on sheet 3 to a columns on sheet 1. such that, I have a table heading on Sheet 3 thus: (S/N, Name, Amount, Loan, etc), also on sheet 1 there's a table header namely: (S/N, Name, ........., Total Balance, Other Services). So that the total transaction (i.e. Amount + Loan) made on sheet 3 generate with user form 4, to be added to sheet 1 column (Total Balance) . Looking forward for a quick response. Thank you so much.