access data from worlksheets

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 ?


By: golfer

Leave a Reply

Your email address will not be published. Required fields are marked *