You can write series of formulas to do that for you.
However, why do you have separate tables containing tasks?
The overwhelming recommendation in the community is to have a single task table, and then filter out infomration into different views. Rather than the other way around.