Compare a SharePoint List with Multiple Excel Tables; If one of the tables has a row that matches a row in the SharePoint list (based on course name), that table is updated with the list's info

Question

So first of all, I have a Microsoft enrolment form which I’ve automated to feed into a SharePoint list. It's a list of students registered for different courses. I want to copy the student details from the SharePoint list into various excel tables. Each table will be for a specific course. So all students for say Physics in the SharePoint list should be copied into the excel table for Physics and so for other courses.

Course List (SharePoint List)

Course

First Name

Surname

Email Address

Then I have the 3 course tables (Excel)

Physics

Course

First Name

Surname

Email Address

Chemistry

Course

First Name

Surname

Email Address

Biology

Course

First Name

Surname

Email Address

I have;

Triggered a flow once a student registers using our registration form to send the course, name and email address of the student to the Course List in SharePoint (This is working fine already);
But I’m struggling to

Loop through the SharePoint Course List and the excel tables (Physics, Chemistry and Biology) so that once the course in the course list matches the course or name of any of the tables, it should copy the details of the student from the SharePoint Course list to that table
How do I go about number 2 using PowerShell or Microsoft Flow or Both please?

Thanks.