When I enter a simple formula, in my active sheet, referencing another
worksheet: I hit the + sign and the view goes back to the original active
sheet.
I want to keep the view on my data source worksheet and then when I hit
enter the view should go back to my active sheet.
Sample: I hit the "=" sign to start the formula, click another worksheet,
click the cell to use, click the + sign and the view automatically reverts
back to my active sheet. I have to keep clicking the data source worksheet
to add multiple cells from the data source.
What is wrong in my excel setup?

JT