Thanks for your feedback, I gave the (PT0007 - Multiple Consolidation Ranges) in http://www.contextures.com/excelfiles.html#Pivot a shot by coping my set of data on top of the one in file: PivotMultConsolProv.xls then saved and closed it then i opened PivotMultConsolPivot.xls and updated the pivot table and found the following:

my headings didn't appear in the pivot table; however the new data appeared under the old headings!. Also, there is some sort of limitation built in the MS Query as it only returned a partial coverage of my data and the entire list.

Thanks again for you support on this matter.

Tarek