I have a calc file with 20 sheets & sheets contain different names. I would like to display the contents of a cell from each & every sheet to this one sheet called Payroll … for example, i want to get the text in A1 cell in the sheet name “Amanda” to Payroll’s C5 cell & the A1 value in next sheet to “Amanda” & so forth.
I got this
=INDIRECT(B3&".A1")
But for this to work i need put all the sheet names to a column.
How can I directly use these different sheet names in the formula?
Can someone please help me with this?
Thank You