Project management and task tracking for recurring activities

Hello Excel wizards - I know there are many wonderful PM tools out there, but I need to use excel for this.

What I am trying to do: - Build a master list of recurring tasks that occur at regular frequencies (daily, weekly, monthly). I’m planning to organize the columns as: Frequency | Owner | Task. - Based on the master list, I’d like to have a separate tab for Daily, Weekly, and Monthly activities. - Ideally, each tab would automatically pull in the list of tasks with the appropriate owner. - So for ex, the Daily tab would pull in all Daily tasks and owners from the master list. Then I would have a column for each date that the owner can check off for completion. - The goal is to use this as a checklist to ensure recurring tasks are completed.

How can I get the Daily/Weekly/Monthly tasks to pull in automatically? If a new Daily tasks is added, I would want that to automatically show up in the Daily tab.

Appreciate your help and wisdom, ya’ll!