Copy Info without 0's

I have 3 worksheets in our employee time file. The first one is for daily hours, the second is for lates and no show and the third is for the week totals. Since we have a large turn around with employees, the names move around a lot. I want to know if there is a code that I can use that will copy from the first sheet to the others automatically when I change the first one. If the line is blank I want the others to show up blank without resulting in a 0. Is this possible?