Drop Down Navigation for Client

I am trying to create a dashboard for a client that will have a drop down menu for navigating from worksheet to worksheet (and from a cell in a worksheet to another cell in a different worksheet).

excel version: 2010

My goal:

A free floating navigation drop down menu that navigates between worksheets and cells.

Ideally I would like to use "combo box" from Developer>insert>form/activex>combo box because it is free floating and does not size with the Excel column height or widths.

Ideally, I would also like this "combo box" to self populate with a set of links I define in a column somewhere a worksheet so that I can make complicated specific links on the fly

So in the column I would have "June revenue" linking to sheet 2
or "June revenue for Steve" linking to sheet 2 cell a4
or "Income statement" linking to sheet 3