Pivot table for Multiple data sheets

Hi All,

I am using Excel 2010 and I am trying to pull the data from several sheets into 1 pivot table. When i try to use multiple consolidation ranges it does not display the month in a unique column. I've also seemed to have lost the ability to manipulate the pivot table.


I need to sum the ranges and display each month individually. I attached a sheet with dummy data, and a desired look in the same tab.

Any help would be appreciated.

thanks
Alex

I think the easy way to do it will be Consolidate data from all sheets in a last sheet and then use pivot.
my imagination