Google Sheets: Formulas over multiple sheets

Question

Is it possible to grab the contents of a cell from one sheet and display them on another?

I have 4 sheets. And I want the cells of the third sheet to display the first column of the second sheet on the second column.

Answer 1

if you want to get range from another sheet just use:

Replace 'Sheet' and 'A2:C8' with title and range you want to refer

={Sheet!A2:C8}

For multiple sheets

Replace ';' with ',' for horizontal view:

={Sheet!A2:C8;Sheet1!A2:C8;Sheet2!A2:C8}

Answer 2

Add the sheetname exclamation point to your cell reference

e.g. sheet!A:1

Then drag from the first cell down to as many rows as you need.