Combine multiple bar charts into one

I have 3 gantt charts that I would like to merge into 1 chart if it is possible. It is a gantt roadmap for future projects.

There are 3 sheets, one for each department "Shared services", "Supply" and "Range" (would like to keep it like this to make it easier for the users)
Each sheet has a gantt chart in the sheet "Roadmap gantt"

Is there some way to have a combined roadmap chart for all 3 departments without forcing the users to enter their projects into the same sheet?

Have attached an example file. Thanks!