Using Pivot Tables to fill Combo Box

I'm not sure if this has been asked before. I am trying to use 2 comboboxs, combobox 1 that is fill with the titles of the pivot tables and combobox 2 which is pulled from the pivottable named in combobox one. I have 5-6 pivot tables on sheet1 and the combo boxes are on the worksheet "Information". I'm doing it this way to keep out duplicates and blanks. Can this be done? Its supposed to do a search in the long run. Unless there is some easier way I'm missing. Thanks so much. I'm also a bit of a novice at VBA but I'd use it any day!

I have named the pivot tables. 1. Title 2. Month 3. Number 4. Person 5. Area 6. Season if that does help any.

I am still trying to work this one out. As I am trying to get the second drop down menu to pull from a named pivot table. the table is pulling from a list i add to everyday and it makes it easier to cut out duplicates that need to stay in the table and blanks. Can this be done?

I guess here is a make up form.