Get cell value from another sheet in same workbook

[cplmckenzie]

I have multiple sheets in the same workbook and would like to get a cell value from a specific sheet and specific cell. How would this be accomplished

 

[James006]

Hello,

With the source sheet in cell A1 and the source cell in cell B1:

e.g. a1= Sheet2 and B1 = E1

=INDIRECT(A1&"!"&B1)

Hope this will help