Creating a live linked sheet from another workbook

[FadeToOrange]

I have a table in workbook that is maintained daily that includes information on open job roles, departments, hiring managers, status etc. There are 5 different departments that are represented in the Department column on the table. I need to be able to share the table with each department head but only the data relevant to their department (ie the head of Finance and Operations should only have the rows where the department is listed as Finance and Operations).

Without using VBA or macros, I'd like to be able to create new workbooks for each department that show only their data that is fed live from the main workbook that contains all the information. I can create an advanced filter that creates in a new workbook but its just the snapshot of the data at that time and doesnt update.

Is there a way to do this using formulas or some other query?

Thanks for the help.