Create new row in a table whenever x happens

I've been trying to find this on my own, both by trial and error, on searching this forum and on googling in general, but if I've missed that it's been solved elsewhere I'd appreciate being referred there. On to my question.

I'm seeking a way to update a table with rows constantly as new information is included elsewhere in the same or in another worksheet. This feels like fairly basic Excel, but I'm a newbie and I fail to find how to do it. I want to be able to for example have a sheet of an invoice, that whenever it's updated with new information (a new invoice with the same template, in other words), a summary of that invoice is created as a row in a different worksheet, which sums up all invoices. Another way to create the row would be for example pressing a button, saving the page or whatever.

I'm aware that I can simply make two different tables that are linked together from different worksheets, where one automatically copies the other, but my goal would be to be able to erase the old text in worksheet one, and still have the summary remain in worksheet two.

Is this possible with Excel, or should I be looking for another solution?

I'm thankful for any help or suggestions you might contribute. I tried to be as clear as possible, but please ask if I left something critical out.

//quispiam

Edit: To show where I'm coming from, I've generally worked with SQL before. What I want here (with Excel) would basically be an SQL "INSERT" command. I want to put in the information in the same place several times over, and have it pile up in a static table someplace else.