Help with 2 tables to sync data

[Jose_Antonio_Te]

Hello there,
My first post here
I am developing an app concernig covid-19 for my work. The app has 1 table with 2 sheets
sheet1=patients status concernig covid-19, with patients id, name, symptoms, etc and the doctors name (this data sheet is delivered to google sheets every day without the DOCTORS NAME
sheet2= patients file, patients Id, name and DOCTORS NAME (this sheet has all the data from patients)
What I need is to append the DOCTORS NAME to the corresponding patient in sheet1 automatically by cross referencing patientId. Is this possible?
Can someone please help me?
Thanks