Pulling filtered data in by tabs

Hi all. I have a data set that I drop data into month in and month out. Within this data is a column with employee names, a column with employee cost centers they are under, and employee amounts spent. My company has asked me to create a report that has each and every cost center as a tab in the file and just a static template in each tab to track employee spend.. So I removed duplicates of all the cost centers and ran a macro that created 50 different tabs with all the cost center names as a template.. I cannot figure out a way to put a list of all employees that are associated with each cost center in each tab. Attached is an example of unsensitized data for just a small example. I simply dont know how to get an employee list on each tab for the relative cost center that employee falls under. Can anyone help out? any ideas? thanks

They wont let me use a dynamic one sheet file
If I do pivot tables I will have to create 50 pivot tables for each cost center tab.

Again my actual data set is huge so I need something not manual

The key to this solution is pivot tables. You can set a pivot table to give you the breakout you want. Then it's a matter of coding to loop through the cost centers and make a page for each.

I converted the data into a table because tables know how big they are, and any pivot tables build from them will always reference exactly the right amount of data.

I set up two pivot tables on the Pivot Sheet. The first one is actually the report itself, and the second is a list of unique cost center names. Both of these are overlaid by named dynamic ranges so the program knows how much data they return. This sheet can be hidden.

The code loops through the Cost Center List. Sets the filter on the other pivot table and copies the results of the table to the sheet.

On the Control Panel sheet there is a button to clear data. This button clears the contents of the data table. The intent is that you can copy and paste the new data into Cell B2.

Hi dflak,

Excel Forum will not let me download the file you attached, keeps redirecting me to login, anyway you can email me that file
removed e-mail

I really appreciate you helping me and this makes sense but I have to take a look at it to understand fully.