Project Timeline Automation

Hi,

I’m hoping someone will be able to help me- I’m trying to automate tasks for different projects based on a set timeline. I’ve inputted all of my tasks for a range of different projects and essentially would like to know what is the most efficient way to update a work in progress table dependant on the start date and due date of the project.

Thanks!