Add Search Sheet with Macro to existing Exel-Workbook

I have an existing Excel workbook containing 7 Sheets with event descriptions. 6 Sheets are worldregion related (America, Asia, Southeurope etc.) the seventh contains region independent events. If the user can visit an event is always dependent on the office and personal position of the user. Every event is categorized in event types. All events that take place are maintained in the 7 sheets. I would like to have an additional sheet added to the workbook as first sheet. It should contain a kind of search mask (with nice UI) where the user can select his office and his position from dropdowns which are filled based on the available data in the 7 sheets (offer all offices and positions that are really in the data). After these 2 entries are selected the macro shall query the information based on the office and position and populate a third search parameter dropdown with all event-types for which entries are there (for this office and position). When the user selected the third parameter he should be able to click on "search" and see all results that are valid for him in the lower section of the sheet. The sheet needs to be cleared before a new sheet is started. ## Deliverables Due to "non-disclosure-agreements" you will get a sanitized version of the excel-sheet with only 10-20 entries per sheet. The original sheet will contain about 1000 rows per sheet. I need to copy the macro to the original workbook after you finished your work. You should provide a very small description what I need to take over to the original workbook.