The question is best illustrated with an example. Say I have:

```
Sheet1!A1=1; Sheet2!A1=2
```

I want a formula in Sheet1!A2 to be 2-1=1. If I enter the formula as normal with mouse clicks I would have in Sheet1!A2:

```
=Sheet2!A1 - Sheet1!A1
```

How can I have Excel use A1 without a sheet reference:

```
=Sheet2!A1 - A1
```

A solution to this seemingly simplistic example would have a big impact on my work.

`=Sheet2!A1-A1`

works for me. Excel should only require the Sheet Name for cells referenced on other sheets.