1) Hyperlinks - Select the relevant cell and press "Ctrl & K". This will open up the hyperlink window. Make sure "Place in this document" is highlighted on the left then scroll through the list to find the tab name you wish to link to from that cell. Select it and click OK. Repeat for other cells as necessary.

2) What exactly do you mean by "always viewable"??