I'm using Excel 2007/Vista... in older versions of Excel (i.e. 2002/XP),
there used to be a special add-in that would collect data from multiple
spreadsheets and could be used to create a running total. It took some
tweaking to make this work in Excel 2003 and I don't remember what I did, or
know if it is even possible in 2007.

Here's what I'm trying to do...

I want to be able to create an invoice from a template and have some of the
information (invoice #, date, customer, project, invoice total) transfer to a
master workbook. In Excel 2003, if I open an existing invoice and overwrite
the information, I am prompted to indicate if I want to overwrite the data in
the master file or create a new entry. When I create a new entry, the
updated info is saved on the next row beneath the current info. In this way,
I can track all of the invoices I've sent out over time, while still creating
an individual invoice to keep in the project folder.

Any help would be greatly appreciated! Thanks very much :-)