I have a text in sheet2!A1, sheet3!A1,...sheet20!A1 and I want to display those values in sheet1!B1:B20. To automate the work, I put the text 'sheet1' in A1, 'sheet2' in A2....'sheet20' in A20.
What formula should be put in B1 and copy down to display the values from those worksheets?
Can I use INDIRECT()?
Thanks for your help