VBA to generate a report from Excel, two conditions

Hi there,

I have a really simple spreadsheet and what I would like to do is.....you specify a condition and hit a button, and excel generates a report showing how many records meeting the criteria in a given period in a different worksheet.

Please see the attached for a sample description.

In worksheet "Data entry", records are entered here. Reporting period is a drop down. In the "report" worksheet, this is where I would like to show the summary-level report.

For example, a standardized report we would like to see is...... show how many records have target of "Yes" in a specific reporting period. I think I will use a filter(filter on which reporting period) and a button to do the job. The extracted record needs to be in the "report" worksheet with column headings specified.

How should I go about implementing this using VBA?

Thank you for taking the time to help