How does one pull Excel data from 200 workbooks into 1 report?

So how would one go about pulling data from 200 Excel workbooks into one report? Either another Excel book, or a text file or something other than 200 Excel wookbooks.

The workbook is a “form” that was created for 200 students, so the cells I need to pull from are always the same. For Tax purposes the college I work for needs to pull this data into a report. In the past, this was all done by hand in about 3 days. I know there should be a way to do this, but cannot remember how to do it.