Creating a data input sheet with excel

Hi,

So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent to a different sheet, the data that was typed into the cells is removed, and then next time further data is inputted it places the data sent to the other sheet below the previously submitted data?

Most data to be inputted has 1 row and 10 columns. Of which all have to be copied and placed beneath the previous on a separate sheet once a submit macro button is pressed.

Thank you