Pulling Data From ~300 Individual Sheets Onto a Master Sheet

Any all all help is appreciated! I’m operating out of a company SharePoint, as multiple people need to be able to access these sheets. I want to have a Master sheet, that tracks information from ~...