Hello Chris

From the Excel toolbar:

Window>New Window

and set it to whichever sheet you want. Then you need to go Window>Arrange so that you can view them side-by-side.

Richard