Carry variables from one form to another in V

Hello,
I'hv created 4 forms where the data of an application form is filled.I want the data to be submitted only when all 3 forms are filled.The data enters the excel sheet at row 5 since first 4 rows of my sheet are header rows.I hv a variable that will calculate the row numbe to start entring the data each time form is run.I want this variable and its value to be carried till the 4th form and all data to be entered in same row till Submit button is clicked.How do i do this in VBA?Pls do reply me with the code.