Welcome to the Airtable community!
A cascade copy as you describe requires a script. I have written scripts like this for clients, and I find that the scripts need to be customized to each base. Invariably somewhere in the chain of linked records there a linked record field that needs to stay linked to the original record instead of a duplicate, or there is a field that needs to have a different default value from the original.
