Filter employees in a costcentre

[sgolland]

I have a massive table of our employees with various data at the end. I want to view certain bits of data based on the cost centre for each employee, but on a separate sheet so doing a filter won't work. . There could be up to 100 employees in a cost centre, but some have as few as 1 employee.


Can anyone stop me from going out of my mind and inform me how I can do this?

[NBVC]

Please a sample workbook without confidential information showing where the data is located and how you want to filter it in the other sheet.