Search multiple workbooks in a folder and subfolders for a specific string

[jskasango]

I need a VBA code to let me browse to a folder and Search for a specific string in multiple workbooks ((*.xl*) Sheet.Results)) in the folder and subfolders . If the specified string is found the code should copy the entire row into a new "Found" workbook including the headers from the first "Hit" only and any "new" headers in subsequent "finds" should be appended to the right of the "Found".
Any assistance will be highly appreciated. THANK YOU VERY MUCH IN ADVANCE.

 

[NdNoviceHlp]

Sorry. I give up. ROW 1 DOES NOT MATCH ANYTHING FROM THE CORRESPONDING COLUMN ROW 25 DOWNWARDS!!! There is no "entry" in column "A". There is no "stock ID" in column "B". There is no "Name" in column "C". THERE IS NOTHING TO MATCH!!! Good luck. Dave

 

[jskasango]

Sorry. I give up. ROW 1 DOES NOT MATCH ANYTHING FROM THE CORRESPONDING COLUMN ROW 25 DOWNWARDS!!! There is no "entry" in column "A". There is no "stock ID" in column "B". There is no "Name" in column "C". THERE IS NOTHING TO MATCH!!! Good luck. Dave

Dave I am sorry too. I think it is the way I asked that made you focus on the headers. My objective is the data from row 25. I just want to make a stack of rows that contain the hit. Please let’s ignore the headers and just give me all rows that have the hit. That’s all.