Compare ComboBox Value from multiple Worksheets
 

Can someone please guide me in the right direction on how I would compare the
value of comboboxes from multiple sheets.
I have tried different methods like activating individual sheets but nothing
has worked.
The catch here is that the code needs to run automatically and from a
worksheet that does not contain one of the comboboxes that i am trying to
compare.
Any Suggestions?
Thanks for yuor help
Ed