Day and Shift wise allocation from Roster / employee shift schedule

This is along the lines of 'help' rather than claiming to be a solution, as it does not fill in the Seal Checkers field in the same manner as the file attached to post #1. It does however fill the other fields as desired and gets desired information from the Seal Checkers sheet, but not the additional sr.no. and names that were listed.
In all fields the array entered formulas* that get the sr.no.'s are similar to:

Formula:

=IFERROR(INDEX('Roster_Seal-Chek-Sup'!A$4:A$10,SMALL(IF('Roster_Seal-Chek-Sup'!C$1:AG$1=E$6,IF('Roster_Seal-Chek-Sup'!C$4:AG$10=E$7,ROW(A$1:A$7))),ROW(A1))),"")

In all fields the formulas that get the names are similar to:

Formula:

=IF(C10="","",INDEX('Roster_Seal-Chek-Sup'!B$4:B$10,MATCH(C10,'Roster_Seal-Chek-Sup'!A$4:A$10,0)))

The counts for all fields are calculated using a formula similar to:

Formula:

=COUNTIF(C10:C12,"?*")

*Array entered formulas are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.