Copy rows that meet conditions from one sheet to another sheet

Hi
I have 3 sheets "Select", "Master" and "Report" in a workbook. "Select" sheet is for selecting the conditions. "Master" sheet contains all data. "Report" sheet to show the result.
My query is (a) select the conditions (2 conditions) from "Select" sheet. (b) Based on the condition select, copy all rows from "Master" sheet those meet the condition to "Report" sheet. (c) Every time when I select the new condition in "Select" sheet, the "Report" sheet shows the new result based on condition meet from "Master" sheet.

I am looking for VBA codes for this.

I attach the example file for the reference.

Please help on this.

Thanks
Nilamani

Thank you very much for your support. This was my requirement.
Besides, can it be possible without command button. Triggering from selection itself...

Thank you again.

Hi

I face error asking debugging when

1. Added another Company Name in drop down list and run macro. It asks for debugging.
2. When select criteria does not meet, it shows error.

I attach the file once again.

Please help.