You could create two ranges in (collection of cells in a column) , everytime find the last cell with information and add the new information.

There could be two text boxes on the form which you could map with the corresponding ranges on sheet2. Also you could hide sheet2 so that no one could see the data

Another suggestion (Why dont you do the same thing in Access)