Hello,
I have a workbook with a lot of sheets, one of them is an index sheet where I have listed all the names of the different sheets.
In this index sheet I want a second column where I refer to a value (A8) in the sheet using the name of the index sheet. Can someone help me with this question?
I can do it manually by ='sheet24'!A8, but I want it to look at the sheet that is listed in the index sheet.
INDEX:
sheet1
Sheet2
production1
planning1
planning2
.
.
.
sheet104

the names of the sheets are random.
Thank you guys in advance!