Identify table, Get Pivot, Copy the pivot table to new consolidated Sheet

Hi,
Here is a mega project for you... Hope you will help me in this also


I want to make a report of Hrs spent on each category for each project on weekly basis. What I need is a macro which can automate those things for me.


I have attached 2 sample work book and 1 consolidated sheet. What I need is to create a macro which will create a pivot table with the 2nd table present in the main sheet (Where the Item type in A:A is not unplanned activities). I have manually made a pivot table there.
I need to automate the creation of this pivot table, and to get the pivot table data in my consolidated sheet on the designated columns (2-3 columns entirely can be dedicated for this)

Any help pls..


Consolidated.xlsxSample1.xlsSample2.xls


I have attached only 2 sample files. But will have 5-6 files like this

25 views and still no help?