I have done a lot of innovative work, like making report which run over Ipads, lots of chart relaed work like multiple chart types, bubble chart, etc, making add ins, etc. The prime focus is timely delievery and customer satisfaction.
As far as i understand the task, you need to have dropdowns which on changing the values, refreshes the data over the sheet. Also the values in dropdowns will be filled dynamically.