Excel updating databse

Hello, I am somewhat new to this entire forum and excel. I am looking to make 2 sheets. One set would have sort of an invoice template such as regular boxes where you put in the information. Info such as address, model part, phone, etc. I am looking for a way I can have another sheet with just a database. it would be so that I can simply press update or something and it makes a new line in the database with it updating the total cost, name, phone number, etc. I am imaging an invoice template that wouldn't be complicated, just so you can fill it in, click update, the template resets, the info is put into the database, a new line is made with a new number for each time I do. If anything is confusing, sorry, I am always busy working and need this to help me out. Thank you so so much to anyone that helps.

A related post I saw:
I need to have a database that automatically updates itself.
In fact, I have a folder with different excel files, say folder Y (all the same form/template), and the first X cells of these files need to be extracted to another excel workbook (file Z). Every file represents 1 row in workbook Z. But this should be done automatically.
So if I copy a new excel file in folder Y, the first X of this new excel file should automatically (can be with a ‘button demand’) be copied into workbook Y.
http://database.ittoolbox.com/groups...-excel-4896725