automatically inserting data in excel

Hello! 

 

I want to know if it's possible to automatically insert data in excel. 

I want to have two worksheets in excel: one for inserting all the data and another one where all the data will be stored. The first worksheet will contain some text boxes and some drop-down lists where I can insert for example a name, a date... Then I want a button and when I click on this button, all the data that I have inserted will appear in my second worksheet (all in the same row but in the exact column) and will disappear in the first worksheet (so I can immediately insert new data). 

 

Is this possible? And if this is possible, how can I realize this?

If it is not possible to do all of this in excel, does there exist a software that can do this?

 

Thank you in advance!