Perhaps something like this event macro in the worksheet named "Main".

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A5").Value = "REP" Then
Sheets("Request").Activate
Sheets("Request").Range("A1").Select
End If
End Sub

And this event macro in the worksheet named "Request". Change column and
row to suit your last cell in the range REP.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Row = 10 Then
Sheets("Main").Activate
Sheets("Main").Range("A5").Select
End If
End Sub

HTH
Regards,
Howard

"bluegrassstateworker" <andy.crumbacker@gmail.com> wrote in message
news:1154029732.076682.111360@s13g2000cwa.googlegroups.com...
>I am creating a budget spreadsheet and wish to have a macro run
> automatically and navigate to a specific cell of a different worksheet
> based on a determined value of a cell.
>
> For example, Cell A5 in the MAIN worksheet uses a drop down list from a
> named range (RFP, MOA, PSC ...) from another worksheet. If the value
> is "RFP" then I wish to navigate automatically to cell A1 of the
> REQUEST worksheet where additional information is completed related to
> "RFP". I'd reverse the process on the last cell of the REQUEST
> worksheet, sending the user back to the MAIN worksheet to continue on.
> Any ideas??
>