I don't understand what you main requirement is but I can tell you how to do a "Back" button which will always take you to the previous sheet you had active:
In every worksheet put the followning code:
Private Sub Worksheet_Activate()
ActiveWorkbook.Names.Add Name:="prevsheet", RefersTo:=ActiveWorkbook.Names("currsheet")
ActiveWorkbook.Names.Add Name:="currsheet", RefersTo:=ActiveSheet.Name
end sub
then you can put " back" buttons wherever you like ( every sheet if required) and run this code from the buttons:
sub Goback ()
Dim str As String
Dim Lent As Integer
str = (ActiveWorkbook.Names("prevsheet"))
Lent = Len(str)
str = Mid(str, 3, Lent - 3)
Worksheets(str).Activate
End Sub