Macros???

[Alpacino]

I want to drawup a worksheet. Where it gets information from other worksheets on the computer. I would like the work sheet to have a drop down list to select a Dept so they can view their performance but I want the sheet to be blank with only the drop down list on it first. Then after clicking the Dept and press "go" will come up with various tables of info about that Dept. Is this called a control button?? And I'd macros involved.
Thanks
Alan