How to get cell values ​​from one sheet to another Excel?

Question

excel

Hello, how can I get the value of the fields from one sheet to another?
Example:
Sheet1 with data.

And Sheet2 to get the data of all cells.
I've tried =INDIRECT(ADDRESS(1;1;1;"Sheet")), but I don't know how to get data from different cells. As with non-static coordinates.

Answer 1

It is necessary to type the sign in the editing mode of an empty cell =, then go to another sheet and indicate the cells to which you want to refer. At the end press Enter.
Get something like =Лист2!B7for the cell.
Or =СУММ(Лист2!B5:C8)for range.
You can also call the formula window and, without closing it, go to another sheet and specify the desired cells as parameters.
In short, the main thing is that the sign =
Well should be the first character, or manually type ИмяЛиста!(with an exclamation mark at the end), and then the coordinates on another sheet.
In Google Docs, everything is the same, just more quotes:='сотрудники'!F26