Getting a Sheet to Choose to Display Other Sheets
 

Hello,
I have a payback workbook with about 6 different payback sheets, for the
six different years in our payback range. I would like to create a master
sheet and link the 6 different payback sheets to it, so whenever I change
some numbers on my formulas sheet, the master sheet selects the correct
payback sheet to be displayed.
In short, I would like to know if I can program a sheet to display other
entire sheets?
Seems tricky to me, feel free to ask for clarification of the problem,
It's difficult to word.
Thanks as always,
Kyle P.