I am looking for a sort of drill down reporting feature.

I have two workbooks. WB1 and Wb2.
Wb1 has cells with red or green color based on some criteria.

When clikced on any particular red cell, it should open Wb2 and show only
that information for that particular cell value.

How we can pass the clicked cell value to the other workbook, based on which
I can filter the data in Wb2 and show only relevant data. If we could some
how pass some range of values in the clicked cell row in Wb1 to Wb2, it would
be more better.

Thanks in Advance.