Pivot Table Formula Dependant On List Selection

Im trying to create a 'drill-down' interface with the GETPIVOTDATA command.

I believe (but im not sure) that this will require several different formulas.

e.g., assuming this formula resides in A1, this returns all data in the pivot $A$6 for Monday of 6/1/2009:



=GETPIVOTDATA("Sum of Mon",$A$6,"Week", DATE(2009,6,1))

however for cell A1, if the user wants to drill down, then the required formula expands to the following..in this case we are drilling down to Name=Baby Becket/Ball, Stage=Infant..and so on..



=GETPIVOTDATA("Sum of Mon",$A$6,"Name","Baby Becket/Ball","Week",DATE(2009,6,1),"Stage","Infant","B/L","B","WL",)

Essentially, without writing a bunch of IF's in the formula for A1...is there a way to put these formulas in a lookup table, and then depending on what the user chooses on how they want to analyze the data (e.g., they may select Name, Stage, etc from a drop down list elsewhere on the sheet), the appropriate formula is populate in A1?

In a nutshell: Can the formula of a cell be changed depending on what the selection value is of another cell or list value?

This could probably been done easily via VBA, but if there is a formula or vlookup based solution that would be easier..