Multiple sheets with names and data from Word files

[knpaddac]

I have approximately 1,200 Word files and I want to create a single Excel file that has a sheet titled for each of those Word files. ALSO, I want to copy all of the contents of each Word file into A1 of the sheet that matches it. Is this possible to do with a macro? Otherwise, I have alot of copy/paste to do.

 

[knpaddac]

I guess that I am lost on the 'add the Word references'. Not sure what I need to do there.

 

[knpaddac]

Sorry, disregard...I do believe I have figured it out. Thank you very much for your help. This will save hours of time.