populate cells in new "log" worksheet from three separate worksheets used as different invoice templates

[patrabil]

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).

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

 

[RJPotts]

Hi,

I tried an example workbook with 4 sheets, 'Log', '1st', '2nd' & 'Final'

In sheet '1st' cell B1 I entered 99/1 as invoice number and in cell B3 111 as an amount.
In sheet '2nd' cell B1 I entered 99/2 as invoice number and in cell B3 222 as an amount.
In sheet 'Final' cell B1 I entered 99/3 as invoice number and in cell B3 333 as an amount.

In sheet log I used cell A1 to enter an invoice number and in cell B1 entered the formula;

=IF(A1='1st'!B1,'1st'!B3,IF(Log!A1='2nd'!B1,'2nd'!B3,IF(Log!A1=Final!B1,Final!B3,"Not Found")))

Is that the sort of thing you're looking for?

Best regards
Richard