Populate some of the student data from the main table to each of the student tables by Stu

Hello,

In an Excel workbook, I have a tab/worksheet with a main table of all students and corresponding tabs/worksheets of smaller tables for each student. I'm trying to populate some of the student data from the main table to each of the student tables by Student ID. I'm tried all kinds of INDEX/MATCH combos and learned about the SMALL function with IF and to add the Arrays "{}". However, I keep getting all types of errors and when I created a formula that worked, it repeated the same 1st row value of the Student ID or skipped the 1st of the Student ID. Please help. Below are attach examples.

All Student Activity Listing.jpg

Abioye Adeboyejo.jpg

Addie J Stevenson.jpg