Summary report - aviation industry

hello everyone .
please take a look on the attached file test.xlsx


here is what i want : take a look on N12345 Data

- i want to generate the following reports but in a way where i can choose from a drop list the following (date Range- aircraft type or resource)

after i choose that now i want the following type of reports that i can choose from a drop list:

- total block and flight time hours per aircraft tail number(resource)
- crew total block hours
- passenger total block hours
(for crew and passenger total hours, I used the sum product formula)

- passenger total flight (sometimes passenger fly different aircrafts )
- total flight per destination

i want these reports to be generated in pdf file . also, i need them to be included with a chart . (preferable chart clustered column layout number 5)

is that doable in Excel for these reports?


for future wise, i would like to take this as extra step in future as i want to make a website for data entry and generate these reports . but my question for this second request. is it possible to use these database i have in excel to be imported in to html website ?

no one have an answer to this ? at least guide line maybe ?