Referencing Cells in Different Sheets on the Same file in LibreOffice CALC

asked 2016-07-08 11:39:11 +0200

ChamiLG gravatar image

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

edit retag flag offensive close merge delete