Need a macro to copy multiple word files with tables into excel workbook

Hi All,

The macro that I need should essentially do the following:

- I should be allowed to select the folder
- Folder will have sub folders in which the .doc files will be placed
- The .doc file will have a single table with 4 columns and multiple rows
- Macro should create a excel file for each sub folder
- Each .doc file in the sub folder should be copied into a workbook as individual sheets in the main workbook in that sub folder
- The sheet name should match the name of the word doc
- The workbook name should match the sub folder name

I hope this is not too confusing.

Really appreciate all your help!!

Thank You in advance.

Please help me crack this guys.