I have 10 tabs in my Excel workbook, each with a different inventory category.


I want the first tab to automatically populate all the "yes" responses in a Yes/No column on the other tabs if I need to examine an item in that tab. How can I do that?

So Tab 1 Is a Master Inventory Inspection List
Tab 2 is Fruits (with multiple rows of differnt types of fruits)
Tab 3 is Veggies (with multiple rows of different types of veggies)

If an item on tab 2 or 3 is flagged "yes" in a yes/no column, I want to auto populate it in the master inventory tab so I quickly know which ones need my attention. Can someone help?? Thank you!