Need to create report using Advanced Filter, multiple filter criteria and Hidden Sheets.

Hi,

I am fairly new to Programming, VBA and Macros and require some guidance.

I have attached an excel database for monitoring servicing of aircraft. I have created a report sheet on which I would like to filter information as follows:
- On the "Report" sheet in top left, there is an advanced filter inserted. When selecting a specific aircraft from this list, I need the information to automatically carry over onto the report sheet. For example: When selecting from the Drop-down "ZS-HKV" and press "Go", all information should copy into "Report" sheet from "ZS-HKV" sheet.

- After this information is carried over, I then require to further filter the information based on the CheckBox selections in blue. The Checkboxes should be able to operate individually if selected or if selected together. I do not know how to do this. The Checkbox for "Next Calendar due time" also requires an automatic limit to only filter items coming up within the next 30 days.

Any guidance appreciated.