Hi guys and gals, for my IT coursework (college) i have been asked to design a spreadsheet system for a new car company. I have a problem that i've been stuck on for a few hours now. I find spreadsheets very hard so it might be really easy. Just hoping anybody is able to help me.

Here's the situation:
I have this form: http://img.photobucket.com/albums/v2...c/hghjjhjh.jpg (a picture of it there)
and i need to create a macro so that when i click 'add customer' all of the details are transfered into this table on a seperate work sheet. But obviously i need to make sure that when i next press add customer it doesn't overwrite the previous details i added.

(http://img.photobucket.com/albums/v2...fc/yyyuyuu.jpg) a picture of the second sheet there.

Hopefully that makes sense and someone is able to help me because i am really stuck.

Thanks a lot in advance, Tom.