help moving data to a spreedsheet!

[tonylpcs@yahoo.co.uk]

Hi Everyone,

Hope someone can help me,
i have a spreedsheet and i need to colate information input on one page into another page!

as an example

sheet1 is the page used to input in the data, and i need this information moved to sheet2 the next avaliable line.

so if for instance sheet one had the ffollowing data on it, it would look like this:

Colums: A B C D E F G

ROWS: 1 C, Name
2 John
3
4
5
6

i want to be able to click on a button and have it transfer all the input infomation onto sheet2 in line format starting at the next avaliable line?
can anyone help?

please?

Tony