Processing Data From More Than 300 Workbooks

I have more than 500 list of workbooks, each workbooks having data filled with 25000 Rows and 15 Columns.

I want to filter and summarize the entire data to know different parameters of the data for example a filter by different States, A subtotal of different states that might tell me:
CA: 40000
NV: 86222
FL: 63525

Is it possible through MS Access? Or Through SQL? (Does Access and SQL have an option to import multiple workbooks at a time?)
or through VBA? or Applying Formula by giving references from closed workbooks?


Any advice will be very helpful!

Regards,
Faiz