Need help with creating an events macro or some other way to have my excel workbook duplicate a cell(invoice#, F4) from my invoice template worksheets "1st..2nd..or Final" to my Invoice# log Worksheet, so that the rest of the info will automatically populate within the Inv# worksheet. It would also need to be directed to the next empty cell in Column A, Inv# sheet.

Is there maybe a better way to do this??, cause I will be reusing source sheets as they are only set up to use as templates, and then save to a non-macro enabled workbook (from within another macro).

I've provided the workbook attached so you can see where I'm going with this. Thx, P