--------------------------------------------------------------------------------

Can anyone advise..how I can create an ongoing "log" to automatically populate inv#, date, customer, and amount, pulling data from three other worksheets using identical templates (for 1st, 2nd and final invoices). I've attached workbook, so you can see, it's not too complex, but I'm still learning.

Since they are only templates, every time I create a new customer invoice by reediting , it changes the previous entry in my "log" sheet, the way I currently have it set up. Obviously, the invoice# is the one unique factor throughout. All 4 worksheets are within the same workbook.

It would be great if there were some way to tell the "log" sheet to extract the date, name & amount no matter what worksheet contained the source data, by inputting the invoice number alone (in Col "A"). I do have a formula (using vlookup) unique to each of the existing 3 worksheets to generate an invoice#, so I'm not sure if this could interfere..although there's no problem to copy/paste. Any help, anyone??
PAR