If i create say 500 spreadsheets in excel with information in specific
places. Is it possible to run something to pull all this info and do a
summary of the information?

I am guessing excel will struggle with the amount of data so maybe MS Access
would be a better choice? if so would it be possible in access?

and how difficult is this?