Macro for Pivottable

[INOPOOL]

Attached please a the data I get every month more or less. I don't want to build a pivottable manually anymore. Is there a macro that will spped up the process where people only to run the macro for Excel to build the table on its own once the recording is done?

http://www.box.net/shared/o4en5zdhc6

 

[INOPOOL]

the pivottable should be set up this way:

department in column labels,
cost center row labels,
and count of employees

thanks