I have my company inventory on 15 different excel 2003 worksheet files. Is
there any way to consolidate those file and reports for each item? I do not
want the Pivot Table way. Because the structure of the worksheets is not
comfortable for that.

Satya Nanduri