Hello all,
I have been working on a worksheet that I will use as a log, and to complete it I would like to copy a line with a specific key word into the corresponding sheet.

I have 5 sheets in my workbook (the main database named "log", "Bill", "Tim", "Marty", and "Dave").
When their name appears in the engineer column which is column D, I would like it to automatically copy the line into their respective sheets.

How can I set this up?

Many thanks in advance!
Nikki