How to set up multiple Activex comboboxes using the same code (dashboard)

Hi

I have 2 dashboards (each one on individual sheets) in an excel 2007 file. On one of the dashboards I have 2 combo boxes and 2 radio buttons. Each combo box and radio button is a pairing so that the user can click a radio button and the subject in the 'paired' combo box will be the master and the other combo box will dynamically update based on the selection in the first combo box. For example: Combobox1 is a list of countries and Combobox2 is a list of sports. If I choose 'country' to be the master, Combobox2 will be updated with all the sports for a given country; if I choose 'sport' to be the master, Combobox1 will update with all the countries that play the selected sport.

I need the 2 combo boxes and 2 radio buttons to appear on both sheets and for them to updated when any selections are made on the other sheet (so that you can move between the 2 dashboards and view the same data).

What is the best way to do this?

Thanks