Searching all tabs

[petro62]

So I have a tracking sheet for projects. What I have done is built a tab with a template for critical information to enter in project status and results. It is a cleaner worksheet than the man sheet which holds all of the information and from there I pull that to powerbi and also I have to send that master list to corporate owners.

So a project manger will copy an existing tab template, rename the tab with their project name. They will then fill in there info in that tab for their project which also includes a cell for project name.

From there I would like the master sheet to look through all tabs for a matching project name and then fill in all the cells on the master sheet from the project tab.

So on my master list it would go like this:
Type in Project Name into column B. Excel looks through all the tabs and finds a matching project name and then proceeds to pull data from that tab and fill in the master sheet information.

I would prefer this not be a macro, but maybe it is required. I was thinking Vlookup, but I thought that meant I would have to define each tab in that formula. So is there a way to do a vlookup that just searches a specific cell on every tab?

 

[petro62]

Would this be done with a version of Indirect Vlookup?

 

[petro62]

So below I took a screen shot. So the Projects tab on the left is more of a database and it is the sheet I want to pull information into. The test tab you see select on the right would be an example project worksheet. The Test worksheet is where the managers would fill in their project info (each project with its own worksheet). Everything you see on the Test worksheet would be pulled over to the database(Projects)sheet. I am just trying to make a more user friendly sheet for project managers to regularly update their own projects so I don't have to.

 

[petro62]

Is there nothing I can do for this? I wish I could have edited the title maybe that is what is driving the low/no interaction.