Yes... MS Query would
1)Combine a-g.xls and h-z.xls into one "table".
2)Combine 238.xls (and whatever other prefix files you have) into
another "table".
3)Find all items that are on both tables.
and
4)Put that list into the new workbook.

If that is something you want to learn to do, let me know.

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=376599