Referencing a cell & output required

[hsandeep]

In my Excel workbook, there are 2 ws: tab named "4" & "5" respectively.
In 4:
AA2='5'!Z13

Output required: in cell AJ2 : the value in cell D13 of ws "5" by using reference to the cell content of AA2.
How to accomplish?

 

[hsandeep]

what the ws 5 Z13 contains.[/QUOTE]

Z13=513.35 (a numerical value)

 

[ricardomadaleno]

if Z13 countains a numerical value then what do you mean by

Output required: in cell AJ2 : the value in cell D13 of ws "5" by using reference to the cell content of AA2.

I don't understand what "513.35" has to do with referencing the cell D13 of ws "5"...