I have an existing formula in a cell as : =[Sample.xls]OC1!$F$1
You will understand that it is taking the value of the Cell F1 of Sheet OC1 of the excel workbook Sample.xls

I do not want to hardcode the sheet name, how to write the sheet number there… The sheet name can change but the number of that sheet wont.
something like =[Sample.xls]'Sheet(2)'!$F$1 ' I know it wont work, but somthing like it

Suggestions invited on how to do it.

Regards,
Rahul Nair