Pulling information from other work books with filtering and source id.

Hi there. I've just thought of something that might help at my work. In our department we have three teams: Chemistry, Physical, and Petrography. Each has a spreadsheet for their work. We all do different tests obviously but this can and often is on the same project. I'm wondering if we can have one workbook that pulls the following from each work book: project number, client, project name, due date, and team. It should also exclude any projects with a completed date. Is that something reasonably do-able?

My first thought would that this would be easy if each team had a worksheet in one workbook and we just had a dashboard but I'd expect some pushback on that as each team is quite protective over the project tracking for their own team.