Adding data from one worksheet to another using a macro button

[ecushion]

Hi

Wondering if anyone can steer me in the right direction. I have created a spreadsheet where in sheet 1 I have athlete testing data. Then in another sheet I have the database which is a simple sheet with all athlete's data i.e Name, Date, BW........
What I am trying to do is be able to just type the data in sheet 1 and then use a macro enabled button 'transfer data to database' so that it adds the new data to the database sheet without me manually doing it each time.
I have managed to do this but it with only do it for one athlete. When i then change the name and data it will just change all the data on the database sheet to this athlete and will not hold the previous data there.
Is there a way I can stop it doing this so I can end up with a spreadsheet of athlete data?

Thanks

Emily

[davesexcel]

Show the code you are using.

[ecushion]

All I am doing is recording a macro - in database sheet A1 = then back to sheet 1 and select the correct cell (i.e Athlete name) and the press enter and repeat for the rest of the data in the row in database sheet. Looks like this......='Data Sheet'!D5
I then insert an extra row as i was finding it was just over writing what ever was in row A2 in database and then stop recording macro.

This is what happens when i try and add new people it just turns all the rest of the data into the person i have just added

Name Date BW RHR Urine 1-5 40cm RSI @ 200ms Squat Jump Signs of Illness Sleep Hrs Sleep Quality
Emily 18/11/2012 68 50 3 3.2 45 N 8 5
Emily 18/11/2012 68 50 3 3.2 45 N 8 5
Emily 18/11/2012 68 50 3 3.2 45 N 8 5
Emily 18/11/2012 68 50 3 3.2 45 N 8 5

[davesexcel]

If you show the code, somebody can probably figure out what you are doing.