I have 100 word .doc files, each file name is "Section A.doc" and each file is in different folders
I want to search file which named "Section A.doc", then open all 1 by 1 copy the entire data in new excel sheet in same workbook. Like sheet 1 to sheet 100 contains each word file data
I know...