Cross board automation that creates subitem

I’m trying to replicate a function in Salesforce that allows me to associate Event Campaigns with a Contact by noting their RSVP status to the respective event. Is there a way to create an automation that does the following:

When Status changes to RSVP Yes, then create a subitem in another board (my Contacts board) under the item that has the same name. Name the subitem EVENT XYZ and mirror RSVP status.

This would allow me to tie RSVP details across multiple events to specific people in my high level Contacts board.

Alternatively, if anyone else has other ideas for how to replicate this function, I’d love to hear them!