Reorder Rows and Sum column totals given specified criteria

Hello fellow excel forum members!

I have a census of data in one tab which includes employees, their spouses and children's information, include last name, first name, what they are (i.e. Employee (E), Spouse (SP) or Child (C), and the monthly premium their policy costs.

In another tab, I need a formula that will take the data from the MASTER tab (see attached), and shift the information upwards so that only Employees appear in the attached FORMULA Sheet tab, not spouses or children, but I need this FORMULA Sheet tab to correctly capture the monthly premium from the MASTER tab for the correct employee.

So as the 3rd tab in the attached sample file shows, Heidi Adams has an insurance policy for herself and two children, so the premium that needs to be captured in the FORMULA SHEET tab in the column "Premium for C (if applicable)", needs to return a result of $202.00, so on and so forth.

Thank you so much in advance!

Be Well