I have a excel sheet set up as a form for the data entry. I want to create a button on there that says submit. When they click on it, the data is put in a list on another sheet, the form clears and is ready for the next input. This would be used to compile a large list so each new submitted data should fall into the next empty line on sheet 2. Does this make any sense?

u can have it also without any macro . If the sheet on which u want to have ur inputs has a line with titles and all ur datas lines placed down this title line (without linespace between title and data), point on any row i it and choose data/form (my xl is a french one and it calls "donnée/grille"). It'll automatically consider ur schedule as a database, and with that auto dataform u can add/remove/search for any data. When adding a new one, it'll automatically be placed on the next empty line, and so on, even when a data is removed. It's magical...!