Periodic Report

Dear users, Thank you in advance for any help you provide me with my post
I was requested from my manager to create a periodic report according to data entry sheet the report is not specified as daily or monthly, i will try to provide you as much information as i can so you can be able to help hopefully
you are free to review the attached file
they are requested to generate a report based on dates selection (From : To)
by entering the dates in the cells (!SheetReport:C5,C6) they want the report to extract the data from DATA ENTRY SHEET regarding each salesman and according to the selected dates
the total offers send for each salseman
the total pending offers for each salseman
the total accepted offer or each salseman
total amount of only accepted offers for each salseman

I tried to search for VBA formulas without any suceed

Thank you in advance for your help

Regards