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!