Cascading timelines by linking timelines

@YveNigma I already tried that approach. However, this approach simply copy-pastes the date from the source sheet to the desired date cell on the destination sheet which does not serve my purpose. What I want is the end date or any other date of the dependable task on the destination sheet to be the next immediate working date that gets auto populated on the basis of the date mentioned on the source sheet.

For instance, the end date of “6.3 Sub Task 18” as seen in the 1st image below is 12/25/24 (25th Dec 2024) and the start date of “7.1 Sub Task 19” as seen in the 2nd image below is also 12/25/24.

Image 1:

Image 2:

For your information, image 1 is a different sheet (named as “Sheet 2”) and image 2 is a different sheet (named as “Sheet 3”). Sheet 3 is the destination sheet and Sheet 2 is the source sheet.

What I want is the start date of “7.1 Sub Task 19” to auto populate the next working date on the basis of the end date of “6.3 Sub Task 18” without the need to add “6.3 Sub Task 18” in Sheet 3.

I hope I was able to explain it.

Thank You