Project Overview Sheet and Auto-populating Data

Hello,
I am building a project management document in google sheets that is divided into tabs by department, with a general overview page. I want the tasks inputted in the separate department tabs to auto populate into the overview section of the worksheet. All the sheets in the workbook have the same formatting. The columns read task, department, due date, and status. For example, if I input "Task 1" into the Investments sheet, the task name, department, due date, and status need to also appear on the main overview page along with tasks from other departments. The overview sheet will show all the tasks from many departments, their due dates, and statuses toward completion. I have been researching how to solve this issue and have been struggling with the coding as a newer excel/google sheets user. Any help would be greatly appreciated! Again, I am using google sheets because this document needs to be shareable across departments.


Thanks for the help!