Name of Sheet in Formula??

[FinancialAnalystKid]

I have a Worksheet titled: "Summary Sheet"

In a "TOTALS" worksheet I have the name of that Worksheet "Summary Sheet" in cell c9.

How do I write a formula that points to c9 so it can reference Summary Sheet so a user can type the sheet they want and get the result.

Right now it is this: ='Summary Sheet'!B133

It needs to be more dynamic as there will be a drop down pointing to different sheets in order to retrieve the result.

Thanks,
Desperate

 

[VoG]

Try

=INDIRECT("'"&C9&"'!B133")

 

[FinancialAnalystKid]

Thanks!!!!!!!!!!!!!!!!