Welcome to the community, @Andrew_Shapira!
The short answer is: No, you will have to do this manually or write a custom JavaScript to help you with this.
The long answer is: Airtable is a platform of many (many) limitations, which places it at the very low end of database platforms.
Unfortunately, what you want — dynamic filtering of linked records — is unavailable natively in Airtable, even though people have been requesting this feature for 5+ years,
I would highly recommend emailing support@airtable.com about adding this feature to their product, but sadly, Airtable also has a history (or perhaps an internal policy?) of ignoring user requests. It makes Airtable one of the more frustrating products to work with. But at the very least, I think you should let them know that this is an important feature to you.
However, you can use JavaScript to create your own custom additions to Airtable with their scripting app, so if you know JavaScript, you can likely create your own app that will let you limit your linked record choices based on dynamic conditions.
There are also several JavaScript experts in these forums who may be able to help you with this.
