Help on copying details from 1 worksheet to another
 

I am fairly new at the Excel software, i can work my way around most
things but just need a little help on designing the final part of my
project.

I have created my worksheets so far, and i have created boxes on say
for example sheet2 with information that needs to go in them, and a
spreadsheet waiting for the information on sheet1. What i somehow
need to do, is fill in sheet2, click on the save button at the bottom,
and all of the information be moved from sheet2, to sheet1 and
clearing sheet2 again. This will be done hundreads of times so will
also need it to move down a row on sheet1 every time. Can someone
advise will i need a macro or is there some easier way of doing this
please?

Cheers,

Phil