Excel 2007 : Combine worksheets with criteria

[ddcell]

Please , help. I need combine worksheets with criteria. This is my example file :

Combine with criteria.xlsmI need vba code..

Thanks..

[MarvinP]

Hi ddcell,

Your problem looks like a Consolidated Pivot Table to me. See if the attached helps or read
http://office.microsoft.com/en-us/ex...010226585.aspx

That way you don't need any VBA code as the Multi Range Pivot Table may be what you really need.

[ddcell]

thanks for your help,Marvin. but I really need is vba code. Combine data from many sheets and filter .