Automation for creating a Template of new child rows when a Parent is copied from another sheet?

Ann.Cracovaner

I'm working on creating some workflows that will copy information from a change order tracker sheet into a resource assignment tracker sheet. Ideally, I'ld like to grab key details from the change order tracker (number & name) over to a resource assignment tracker, then have additoinal rows added on the resource assignment tracker to break down the change order into individual tasks.

Is there a way to set this up with an Automation? Or a set of formulas that will work for this?

I know I will probably have to manually make the new rows into child rows, but having everything automatically entered would be wonderful!