Linking columns from master to sheets

Is this even possible with a function or formula?

This is my first attempt working in Excel. I have a master spreadsheet with columns of user's names, dept, email address...etc. What I want to do is list different departments (from the dept column) into their own seperat sheet but still linked to the master. So If I make changes to the master or add someone to that dept, it will add it to it's own "dept" sheet as well. Hope this make's sense. Thank you for your time.