Consolidating data from multiple worksheets into a summary sheet having multiple criteria

Hi There,

This is my first post.I need help with either a vba / formula which will help in consolidating data based on multiple criteria.

I have attached the document which contains the following (only main sheets mentioned below)

1. Top Risks Landing Page :Pick up All the risks, only from the sheets highlighted in Green, based on the "Risk Category" or "Rating Column" and consolidate them into the "Top Risks Landing Page" in this order

•Region ( Apac,Americas,Emea,Global)
•Business Unit (A, B C)
•Risk Category
•Rating

In addition to the displaying all the RAG items, can there be an option of selecting the month and the status and based on the selection, the data should be displayed.Have also mentioned this in the attachment.

2. Regional View : It should then pick up the risks Region wise from the "Top Risks Landing Page" and put them in the 3 sheets titled " Americas", "APAC" , EMEA" respectively in this order

•Monthwise (Or give an option to select the month, and based on the selection display the data in the order below)
•Region ( Apac,Americas,Emea,Global)
•Business Unit (A, B C)
•Risk Category
•Rating

Note : If the Region column has " Global" mentioned , the issue should populate in all three regions.

3. Top Risks-Red Items : Next it should pick up only the Red rated items from the "Top Risks Landing Page" and consolidate them into the "Top Risks-Red Items" sheet in the same order as in point 1.


4. Top ICSS Risks : The "Top ICSS Risks" is the Final Sheet which should capture data from the 4 sheets namely :

i) "Top Risks-Red Items"

ii) "Macro View"

iii) "Regulatory View"

iv) "Forward View"


I have written some comments and notations in the individual sheets for reference

If you think there is a better way of doing this, do let me know.

Since this is an urgent requirement , would appreciate your help at the earliest.

I intend to go through the tutorials as well since im new to vba . I will do so in due course.

Thank You once again.
Marushka

Hi

Could somebody please provide a solution.Its been quite a while

Kind regards,
marushka