Put everything in one page

Yes, no, maybe?
To pull data from pages dynamically, you could use INDIRECT(string_of_address_you_want). Something like:

Please Login or Register  to view this content.

Or, you could use CHOOSE if your sheet aren't named to take advantage of a number variable.

Please Login or Register  to view this content.

Or, you could use pictures of the cells to see the values. Create a picture, then use name manager to create formula to something dynamic (using functions similar to the ones above, but for the entire range of the picture), then change the picture's formula to your named function. Plenty of tutorials on line with the details and pictures.

But, these would all just show the values. I infer that you somehow want the formulas to also be carried over to the new page. Nope, not without some tricky macro.

So, do you need help with the srcoll bar or displaying the data?

Just create a scroll bar, use that selection as the 'key' to determine which block of data you want to display. I also thought the data source spanned across multiple sheets, but it appears it is all on one sheet. Not a big difference, since you should still be able to use the techniques I describe above. The INDIRECT and CHOOSE options would require you place those functions for each cell you want to bring into your main sheet (i.e. if the table is 5 rows and 6 columns, then you would need to do 5 rows and 6 columns of INDIRECT or CHOOSE formulas to pull in each piece of data).

If you only need to see the data, then I would recommend using the picture solution since that allows you to also present different sizes of pictures. Note, these are not actual jpg pictures, but dynamic 'windows' to the focused cells, as described here:
https://support.office.com/en-us/art...5-06d112c2099f
In the section "Dynamically display cell range contents in a picture"

Then, you would use a similar technique (although I would recommend CHOOSE for the Name Manager equation instead of the INDIRECT(ADDRESS(..)) one they use) as described here:
http://blog.extrobe.co.uk/blog/2015/...cell-in-excel/

Here is an alternative solution I found (but I think the pictures are better since it would carry over the formatting you probably want):
https://stackoverflow.com/questions/...range-of-cells