Dear all,
I have to work in an excel file with a large number of sheets, then I have the main file where I look up the data from the different sheets using lookup formula "=index()".
wherein this context I wanted to know if they're a possible way to select the sheet name from the cell "A1" to the formula.
main thing is I don't want to go in every sheet to select the range in the formula.
is there any possible way.
To make my question clear I've uploaded the file, please check.
regards,
Bookmarks