If you have multiple row fields or your column field
is listed in rows, then
Multiple Consolidation Ranges will not work.
You can consolidate your data on one sheet
using names that refer to the source data.
Maybe like this:
http://www.freefilehosting.net/download/3a5ea