Transfer Data from Multiple SharePoint Workbooks into Master Workbook Automatically

Would like a VBA code to transfer data from 25 SharePoint workbooks (each workbook saved with different name) as data are being entered in column A, Row A2 through column I, Row I2 to a Master Excel Workbook in the C directory. Sample workbook attached.