Creating a master spreadsheet based on various spreadsheet in Sharepoint

Hello,

I have 4 excel spreadsheets with project information by department posted in each department folder in a sharepoint site and I would like to create a master file with all those departments project information. Is that possible?

Thanks

Luis