Function needed to extract data from one sheet and import sequentially on to another

Hi there;

I am currently looking to create an excel tool to use with a step counter to track progress of steps

What I wanted to do was have an 'input' section in which I can input the data over 7 days, and once complete, essentially 'export' this data in to an archive from which I can do all kinds of charting and reporting etc...

At the moment, I am stuck on how to solution the 'data input' section

Pressumably I am after a submit command button of some kind that, upon invocation, will take the data from 'sheet 1' and import it on to 'sheet 2' in to the next available row?

Are any gurus able to offer an advice on what kind of function could acheive this?

I attach the high-level example to give context (see tabs "Input Sheet" and "Totals")

I don't think this thread crosses any others... all others seem to be orientated to combobox data management or forumla driven solutions.