On sheet1 I have a list of other tab names in column.
i want to access data from those sheets using the column data.
Let A1 column contains worksheet names.
i want something like =sheet1!A2!A1 (i.e data from the sheet name mentioned in the cell A2 of the column ?
please also tell the same shall work in google sheet or not ?