I have one worksheet that is constantly updated. I am creating new worksheets working off of the data input into the original (let's call the original WIP). The second worksheet (let's call this BILLING) is the one I need to build. Each person is to have their own sheets in BILLING and I want the information to be input automatically when WIP is updated. E.g. I am creating a BILLING sheet for DSH (the invididual's ID). I want that row that has DSH as the ID in column E to be replicated in BILLING for DSH. I don't need the entire row, just columns A,B & F replicated. If column E is someone else, I want it replicated in the appropriate sheet but to have nothing entered in DSH. Any ideas? Do I make any sense or am I babbling in Greek???