I have a spreadsheet that contains information on work performed that day

1A DATE
1B WORK ORDER NUMBER
1C TECHNICIAN
1D WORK PERFORMED

I would like to know how based on column 1B to get all the information
entered on Line 1 copied to another spreadsheet. I am sure that the IF
function is used. I have managed to get 1B WORK ORDER # to copy to the other
spreadsheet but have spent hours trying to get the remaining cells to
trasfer. Doing this would allow me to enter infomation on a main spreadsheet
and then it would transfer to a seperate spreadsheet dedicated to that work
order number.