Click the cell where you want the data to appear
Type `=`
Go to the other sheet and click the cell you want to pull
Press `Enter`
Use a sheet reference like `=Sheet2!A1`
If the sheet name has spaces, use single quotes like `=’Sales Data’!A1`
Copy the formula across or down to pull more cells
Use absolute references like `=$A$1` if you want the reference to stay fixed
Use `=SUM(Sheet2!A1:A10)` to pull and calculate data from a range
Use `=Sheet2!A1&” “&Sheet2!B1` to combine data from multiple cells
Use `VLOOKUP`, `XLOOKUP`, or `INDEX` and `MATCH` to pull matching data from another sheet
Use `INDIRECT` if you need a dynamic sheet reference
Use `Paste Special` if you want to link or paste values only