When a column equals a certian number how do i make the entire row copy/ link to ne sheet

I have a master sheet that I am inputting everyone who I am using on what days, times and their tasks. I need to get that information to each department so they can schedule accordingly. I have a column that lists the department of the person that I am using, this can change often with another person from another department. So I want separate sheets or all on the same sheet in sections that as I update my master the entire row of the person, time and tasks change when I change their department.