Hi,

I would suggest trying this website and looking at Multiple Consolidation Ranges. Think it will save you time in the look run

http://www.contextures.com/excelfiles.html#Pivot

VBA Noob