I have worksheets numbered 1 - 26. I am using the following on a woksheet
named 'Orders' to get data from a sheet named '13'
{=INDEX('13'!$B$2:$R$11,MATCH($C$32,'13'!$A$2:$A$4 7,0),MATCH(1,IF('13'!$B$2:$R$2=$D$6,IF('13'!$B$4:$ R$4=$D$8,1)),0))}
How would I alter this to return data from a sheet number I enter into a
cell in my Orders worksheet. I have tried various methods but I must be doing
something wrong.
Any help would be greatly appreciated,

Thanks

Mike