Autopopulate Different Sheets from a master sheet

Hello again,

Is it possible to autopopulate different sheets from the information put into a master sheet?

Information is input into the first sheet and depending on which department the information is for, I need the information to appear on one of two other sheets.

So, I input the relevant data, I mark down that it's for department 1 and on the sheet marked Dep1, the info appears. The same with department 2.

Also, is it possible for the background colour of a cell to be duplicated for the additional sheets without doing it manually?

Cheers

I would like to keep the data on the master sheet. It will remain as a reference for anyone who wants to see both departments at the same time.

Generally, the background colour is just changed manually. As you can see, there is a calender for people to enter their holiday, sick days, etc. If you can suggest a better way of doing this, I am open to any advice.

Thanks

Yes, the next available row for each heading would be used.
As you can see, there are dropdown boxes in column F "Who" that autopopulate the department.

The subsidiary sheets can be cleared, I just used the master as a template and copied over.

I may not need to do this if you could have autofilter on two different rows at the same time.
This would be the best way though.

Every cell has the potential to be updated and all data would need to be copied.