VBA code for reports from all sheets in a workbook

[sushilkadam]

Hi Everyone,

I am in urgent need of vba code for my reports

Attached is the sheet of my documents I get it from different vendors. Column AA contains the different status (e.g. Pending from vendor, Pending for OGC response, Pending for OGC submission etc. etc.)

I want to have a report section, wherein by selecting one type of status I will get list of all documents under that particular status in all sheets of my workbook

For example: If I select status as “Pending for OGC Response” than I shall get list of all documents that are in this status
If “Pending for OGC Response” is in cell AA13 than I shall get the details of A13, B13, C13, D13 and so on till AA13 under heading mentioned in Row-10

Please note code is required for all sheets in the workbook and not only for one sheet

Hope you all understood my requirement and will be very thankful for your help
Any thoughts are most welcome

Thanks
Sushil Kadam