Using the + Symbol in Excel
Start by selecting the target cell (in our case B1 of Sheet 2) and typing in the + symbol.
Next, right-click on the Sheet 1 label button to go back to your data. Select cell A1 and then pressEnter.
Your data will be automatically copied into cell B1.
If you performed the operation correctly, then upon selecting cell A1, you should have the following formula displayed in the formula bar: +Sheet1!A1.
Using the +Sheet(X)!((XY) Formula
The second method will make use of the +Sheet(X)!(XY) formula.
Select the cell in which you would like to swap the data and type +Sheet(X)!(XY) into the formula bar.
Using the conditions above, the formula+Sheet2!B21 will copy data from cell B21 of Sheet 2.