Yes, I would recommend looking into a third party tool like Zapier to help you with this; take you maybe an hour to set up. You can do this via automations with scripting as well but that's probably more work than it's worth
If you're using Airtable's multi-source syncing, the primary fields not being the same shouldn't affect anything as we should have the option to choose which field to send each field's data to, per table, no?
