Linking Multiple Tabs into One Table

Hi everyone,

I’m looking for a way to update records from multiple tabs into one single tab automatically.
For background, I have a base with multiple tabs in accordance to my org’s departments. Every department has its own unique deadlines in accordance with a program/task.

Is there a way to:

1. Create a link, automation, or script to take all of the deadlines from the multiple tabs into one overview tab automatically? That is, every time a new deadline is created in the individual department tabs, it will automatically transfer that date into the overview tab.

2. Create/update records from the individual department tabs and include them in the overview tab?

I had a free consultation that ultimately expired so any help is greatly appreciated, thanks!