Automatically open a file in a specific file path when another sheet is opened

Hi
I want to open a specific sheet and refresh only said sheet when i open another sheet for example x.xls

So opening x.xls will automatically open y.xls

I've tried this in the workbook code area but it doesn't do anything.

Any help would be great

Private Sub Workbook_Open()
    Workbooks.Open Me.Path & "L:\path\path\path\path\y.xls"
End Sub