Go to cell from drop down of defined ranges

[projectile]

Hello

We are trying to figure out how to link a combo box , to a list of pre-defined cell references.
so that the user can select from the drop down box sheet\cell they want to jump to


e.g.

Workbook contains a 2 sheets, one for each dept.

Each sheet contains several tables for each profit week in year.

the corner cell of each table in sheet is linked to a defined name name e.g septweek1(referenced to =dept1!$B$6) , septweek2 (referenced to = =dept1!$B$12)

Hope this makes sense.

Thanks