Display values of all rows from another sheet which contain a certain value

[Galuppo]

Hey guys,

I'm building a form which will record all the tasks that are pending and those that have been completed. They differ by type, say A, B, C and D. The task status is on the column 'A'!B:B, 'B'!B:B, 'C'!B:B, 'D'!B:B

I wanted to generate a report on another sheet.

I'd create a dropdown with ("Pending", "Completed","Delayed") on 'Report'!B2.
On 'Report'!C2, I would put the sheet I wanted it from (A, B, C, D, Total).

I would like to generate all the rows from the specified sheets with the specified status on the cells below after clicking a button.

Would that be possible?

I really apologize for my non-existent VBA knowledge.

Thanks!

 

[Galuppo]

Sorry, I've just realized that the column headings for each type is different. So please ignore the "Total" option for the report.

The data for each sheet starts at row 5. If possible, I would like to include the heading which is at row 4.

Thanks!