I found this macro to extract all the sentences containing a particular term into an Excel file: vbaexpress.com/kb/getarticle.php?kb_id=553

It works perfectly! But I want it to do more. I'd like for it to do exactly what it does above, then repeat the process for a different term, and put that into another sheet in the same Excel workbook (up to 10-20 terms/sheets).

Also, can I tell it to use the "find all word forms" search for some/all of the terms?

I'm working in Word 2007.

Thanks in advance!