master menu

Job ID: 34208911

Budget: $30 – $250 USD

I have an Excel sheet with roughly 25 tabs. On tab 1 there is a list of categories. the other sheets contain the contents of the categories. I would like to be able to clinic on the categories listed on sheet one, have it pull up a drop down of items listed on other tabs, select the items and have it populate a cumulative list on a new tab. Is this possible?
Related categories: PHP Visual Basic Data Processing Data Entry Excel