Generate report based on master file dates and delivery notes

Hello, I need help to generate a report (Sheet "Report-A" & "Report-B" ) based on the dates (column F) and delivery notes (column E) from the master file. Sample workbook attached.

Thank you.

Hi
Use this in E7 and copy down an right

Formula:

=SUMIFS(Master!P$10:P$10000,Master!$F$10:$F$10000,$A7,Master!$E$10:$E$10000,$B7)

Thanks for your help.

Thanks for the feedback and rep.