I would like to search for text across multiple worksheets and summarize the entire row in one worksheet. In my example, I am looking to find all instances where the words "change order" appears, and then copy the entire row into the "Summary" tab so that I can sum the change orders. The attached example is a simplified version, and the actual spreadsheet contains at least 50 different worksheets with various titles.
Any help would be greatly appreciated!
Bookmarks