Emailing Worksheets based on filter

[lyambor]

I tried Mail Merge but because of the complexity/amount of the data it did not work so

I have created a pivot table filtered by school / Principal email - all the data is there as requested
I now have about 80 sheets that I would like to automatically email to each of the principals

Is there a way to do it automatically without having to manually email each principal the appropriate sheet

each sheet has filter fields at the top

School
Principal email

Data across @20 columns

Thank you
Leslie Yambor
Anne Arundel County Public Schools
Maryland