Visual Basic Macro in Excel 97 for submitting data

[Tech Surfer]

Basically I've got a form and a form button and I need a macro to submit the data entry value from certain cells to a hiddent able i've made. But then when another set of data is submitted by the button it then enters the data below the the previous submitted data and so on.

Here are the references to the cells with values that need to be entered into the table:
"B7:C7", "A10", "B12,C12","B13,C13","B14,C14".
The button is a normal Excel form button, though this could be changed into a Command Button if necessary.
The first cells into which I want to enter data are as follows, they are in the same order as above i.e. 1st above inputted into first below:
"A21:B21","C21", "D21:E21","F21:G21","H21:I21"

This is for my A level IT course and my teacher, who's the only one in the school who knows how to do this, won't tell me as he's going to teach it to us in a few months time - but I can't wait, I need it now!

Please someone help me!

[William Allen]

What do you want to do with the previous data? Delete or move it somewhere else?