Alternatively, you can manually write this formula in the formula bar. It should look like =!, where “” is replaced with the name of your source sheet.

For example, if you’re pulling data from cell D12 in Sheet1, the formula should look like =Sheet1!D12.

You can drag and expand the range of linked cells in any direction. This could include the entire worksheet, or only parts of it.