Set and show pivot data's source data. Create pull down from available sheets

[ShadowRider]

I have a number of sheets that contain the results of the same data over different periods of time. I need to calculate the same information for each sheet. I'd like to do these calculations from a single sheet where the user can use a pull down to select the title of one of the aforementioned sheets, and then display the results and the source of the data.

How can I create a pull down with the available sheet name (I'll remove the 'calculation' sheet)?

How can I set the pivot table's source from the results of a pull down of sheets, and then display that same?

Thanks,
-Eric