Pick Up Sheet Name From Cell Value

[MrData]

I want to pick up the sheetname from cell Z14 of a sheet called Summary.

This is my original code

Set Found = Sheets("Sheet11").Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)

I tried replacing ("Sheet11") with this but I don't seem to have it working correctly

Set Found = Sheets(Sheets("Summary").Range("Z14").Value).Range("A4:A85").Find(what:=.Range("E2").Value, lookat:=xlWhole, LookIn:=xlValues)

Can anyone assist?

 

[sulakvea]

you're sure Z14 contains Sheet11, spelled just like this, w/o any spaces?

also, you have an extra period in what:=

what:=. - this one

did you mean to have a sheet name there too?