vlookup match between a tab name and index to bring back a result

[StillUnderstanding]

Hi Everyone,

I have a workbook that has an "index" tab and that pulls the names of the other tabs in the workbook into the page in column A, then in column B I have a "Team Leader".
I have set a range for the titles and for the full sheet.

On the tab called "manage" I have cell E3 that contains the tab name using the following formula "=MID(CELL("filename",E4),FIND("]",CELL("filename",E4))+1,256)"

So on the index tab, cell A2 it now matches what is in cell E3 (The name of the tab) but when I attempt to do a match to bring back the data from the column called "Team Leader" using the below formula it returns 0.

=IFERROR(VLOOKUP($E3,Team_Leader_sheet,MATCH("Team Leader",Team_Leader_titles,0),),)

If I manually type the tab title into cell E3 of the managed tab then it returns the correct result. I think the issue is that a formula is in E3 but I am not sure.

Can anyone help with this please?

 

[StillUnderstanding]

Just worked it out, the issue is with it being a date value and so I used this code:- =DATEVALUE(MID(CELL("filename",E3),FIND("]",CELL("filename",E4))+1,256))