I appreciate the thought but that does seem to be a solution better served for small scale, unless I'm just not getting the concept. It needs to look through 100 separate spreadsheets, determine a positive value in a QTY cloumn, then copy the horizontal values to an ORDER sheet, but ideally from a drop down menu of style, species, and size.

Using Access seems helpful, but the coordinating data from pull down to order seems to be a month long project. Business is slow, but I'd be out of my mind by the end of the month.