Excel 2007 : Invoice and database in one

Hey Everyone!!

My excel is really rusty, which is why I am here begging for help.

I need certain cells on an invoice in excel to automatically populate on another sheet. Each time the data is changed, I need the information to automatically populate on the row below the previous entry.

So let me explain the desired end result. We want to open the invoice, fill it out, print it for the customer, and have the data we need to record and save from the invoice go into another sheet to be used as a "database."

Let me also tell you that I do not know any programming. I did this, or at least something like this, several years ago, but can't find the file and haven't worked in excel for quite some time.

I am using 2003 at work, but 2007 at home.

Is there a way to do this without any VB knowledge? I appreciate ANY help I can get at this point! Thank you, thank you, thank you!!!