In above formula: You are using 5 DIRECTLY. Can there be a formula which can 'identify' the ws tab name & can be used?
Why I require this: Suppose instead of AA2='5'!Z13 had there been AA2='8'!Z13 so I would require referncing with respect to ws 8.
Moreover, something like X rows DOWN & Y columns RIGHT