Jump to new worksheet based on value in cell

[mwardle]

Hello All

I'm trying get a piece of VAB code which when a "button" is pressed will jump to a specific worksheet based on the value in a cell on a different sheets.

The button will be on worksheet called "Balances" the cell value will be in cell G1 on a worksheet called "Summary" and will contain either "Preparer" or "Reviewer"
what i need to happen is when the button is pressed is if the value says "Preparer" i need to open a worksheet called "Preparer" or if it says Reviewer" i need it to open a worksheet called "Reviewer"

thanks for any help which you can give.

 

[footoo]

Sub FT()
On Error Resume Next
Sheets(Sheets("Summary").[G1].Value).Select
On Error GoTo 0
End Sub