Create report/table based on certain criteria

Hi there,

I would like to create a report based on selected criteria.

The user can select their desired criteria & format of the report from sheet1. Then they will click ‘create report’ and the report will populate. In my attached excel template I have shown what would be populated based on the current settings.

Could someone please tell me what is the best way to do this?

Thanks a lot in advance.