Populate Combobox with Pivot Table Data

Hi All. I have been looking through old posts, but haven't been able to
find the right code.

I am trying to populate a combobox on one sheet with data from a pivot
table. Basically, I want the user to be able to make selections,
without having to filter through the pivot table.

Example:

Pivot Data:

Page Field is Ticker
Row Fields are Description and Name

I want the user of the combo box to select ticker. Then applicable
Descriptions come up. After selecting Description, Name selections
appear in combobox...

Does that make sense?

Thanks,

Scott

Did you get an answer to this post? I have about the same problem and haven't found a solution to it online.