Integrate Several Excel Sheets to a Project Manager

Looking to merge information from several excel spreadsheets. Each is managed by a different employee the goal would be to see a Microsoft project schedule with the information from each sheet. In essence it could be used to forecast if we should take on additional work to fill potential schedule gaps of available manpower. Or if additional manpower will need to be hired to meet the contracted work