I am assuming the question is to look at multiple workbooks, and get all the information from the sheets, that corresponding to a specific value in the description column. Can you confirm?

In addition, did you have a look at

http://www.excelfox.com/forum/f2/cop...workbook-1045/
http://www.excelfox.com/forum/f2/fil...al-sheet-1004/
http://www.excelfox.com/forum/f2/cop...using-vba-967/
http://www.excelfox.com/forum/f2/loo...g-formula-848/
http://www.excelfox.com/forum/f2/com...one-sheet-929/