How to keep vlookup constant after changing tabs

*I am using a VLook to find data from a different tab and put it into a chart. Everyday i insert a new updated tab ( with the same name, and i would need the same range from) that i need to use the vlookup on. Is there anyway that i can somehow put something else in the formula that searches for the tab so i don't have to redo the formula every time i insert the new tab


This is the formula i'm currently using

=IFERROR(VLOOKUP(D7,Sheet5!$A$6:$D$194,3,FALSE),0)


I need away to search within the vlookup for the tab then do the specified range every time without manually doing it

I think it has something to do with putting something before the specified sheet but i cant figure out what


This is what it looks like when i put the new tab in

=IFERROR(VLOOKUP(D7,'C:\Users\mdoto\Documents\SJG\[12.9 Credit Report.xlsx]Sheet7'!$A$7:$D$25,3,FALSE),0)

Try this ...

=IFERROR(VLOOKUP(D7,INDIRECT("'" & D1 & "'!$A$6:$D$194"),3,FALSE),0)

D1=Tab name

Is this what you mean?

So i have this =IFERROR(VLOOKUP(D7,Sheet7!$A$7:$D$25,3,FALSE),0) formula in one of the cells. the range that i use for that formula comes from a different tab (Sheet7!$A$7:$D$25 comes from another tab on the excel sheet) . So everyday i replace the tab (sheet 7) that i get the range from with a new tab that i import and call it the same thing. I dont want to have to redo the formula everyday so i need to be able for he vlookup to search the tabs on the excel sheet and find sheet 7 and then include the range that i specify (which is the same everyday)

I dont know how to upload a picture or i would

Sorry for the delayed response, it wasn't working at first than i realized that i just needed to put " " around sheet7 for it to work. Thank you guys very much for the help!!!!!