[Excel 2007] How do I have a sheet name and column reference be dynamic?

Ok, so this sounds easy, but its not. I have a formula that basically has a hardcoded sheet as a reference, but then has a dynamic column/row reference (below). I want the hardcoded sheet to just be a dynamic refence, but i dont know how to do this. However, each time i need to change the sheet name, i have to go and change the hardcode. yes, i know i can do an 'Address' and add a few more columns, but i want to do it more simply.

Example of what I have:

Hardcoded sheet name with dynamic column/row.

Sheet name = TO9
Column = N
Row 5

='TO9'!$N5

Example of what i want:

Dynamic sheet name with dynamic column/row

Sheet name is in cell A9
Column = N
Row 5

=A9!$N5

unfortunalty, i cant find the proper syntax, if that is even possible

PRAISE ALLAH!!!!!

thank you so much, senor