To do List recap tab

Hello.

I'm working on a sheet that is basically a To do list. Every tab is different production (working in the music industry).

The sheet is working jsut fine on its own, easy to read, has progress indicator for each group of tasks (admin, Planning, logistics...), easy to add things without breaking any of the cells. It's great.

BUT

I was wondering if it would be possible to creat a tab where every task due in the week is called back from every other tabs ?

for exemple if for Prog1 I have to send out the contrats, For Prog 2 I have to be finished with the travel bookings, and if for prog 3 I have to check the admin informations, I would like to have in my first tab :

TO DO:

Everything would be automated.

If a task is due this week, it's gonna pop up in that tab as soon as you open the sheet. No matter how much tabs there is, or how much I add after doing this Recap Tab. I don't want to have to change the formulas everytime we add a new production.

Is it possible without being a computer genius ? I'm alright in Excel, but can't really code or anything... I just learned on the job, testing things out...

And, yes, I am very aware that some apps could do that for me... But it's never really perfect for my use. And TBH we already work on so much different plateforms... I can't be bothered to use another one....

Please help, if not possible, it's ok