Want to copy particular cell value from multiple Excel files to a single file

want to copy the value of cell a2 from 100 excel files in same folder to a new workbook file in same column