Vlookup to search undefined worksheets

[petro62]

I have a work book that has a lot of worksheets. Most of the worksheets are individual projects and the project manager goes into that worksheet to update their information as the project progresses. I also have a worksheet that collects all that information into one database that I have to turn in to upper management. I also have a PowerBi pull information from that main database sheet.

Currently everyone has to fill in their information in the main database sheet and it isn't very user friendly. That is why I wanted to create the worksheet form for each project so the project managers can easily enter their information.

Question is this:
On the main database worksheet how do I pull information over to it from all those individual worksheets? Since I will be constantly adding worksheets I don't want to have to alter the formula to update those worksheets. So from the picture I need to match Cell B1 (Test Project) to a cell in B column on a worksheet called PROJECTS. Once it matches then it will fill in the rest of the cells in that row with the correct info. So how do I have a cell search all the existing worksheets that are not specifically called out in that cell/formula?

 

[offthelip]

It is fairly easy to do that with VBA just loop through all worksheets checking Cell B1 against your list of projects in column B and copying the data from that sheet to the correct row.

 

[petro62]

It is fairly easy to do that with VBA just loop through all worksheets checking Cell B1 against your list of projects in column B and copying the data from that sheet to the correct ro

It is fairly easy to do that with VBA just loop through all worksheets checking Cell B1 against your list of projects in column B and copying the data from that sheet to the correct row.

Thanks. After getting some feedback and thinking about it I think managing a lot of worksheets may overly complicate things. I think I am just going to try and build a user form to add new and/or edit existing entries.