Dumb dumb question

[Kiteman11]

So let’s say I’m on a tab 1 and the equation is of tab 4 plus tab %6. There is a way to hotkey to tab 4? Basically I need to find that formula?

 

[Kiteman11]

A%SheetB. If I am on A I shout have a hotkey to get to SheetB. I did this many times in my old job. I forgot how. I was unemployed a year.

 

[KRice]

Are you possibly trying to recall either of these methods (Ctrl-PgUp or PgDn....or right clicking to select tab)? For demonstration...

 

[Fluff]

Try Ctrl [

 

[Alex Blakenburg]

If Fluff's suggestion does work (and it will depend on whether the other tab is the first cell reference in your formula), then
<F5> followed by return should take you back again.
(F5 is goto, Ctrl+G will work as well)