Bob
Thanks for the response, That kind of makes sense that Excel scrolls until it encounters the new active cell. On mine with a new file, Excel still does the same thing presenting the new active cell in the lower left or right of the screen.
I create a hyperlinked index at the sheet beginning. Then I use the hyperlinks to jump to one of the 50 tables I reference, then combine the table info via pivot tables.
Having to scroll to move the table into view every time is just an annoyance. I can find the address in the lower right corner that corresponds to the table being in view, but that also is an annoyance. Changing the table size (inserting rows) changes the screen that is presented.