How to write VLOOKUP to source data from multiple sheets

I have a Master Project sheet and multiple individual project sheets.  I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet.

While VLOOKUP will work, the wizard requires me to know the sheet that I want to search.  I need to reference all sheets in a workspace as the source of the data.  

I tried to manually create the Sheet name and range of cells to look in but that is not working.  I may have the syntax wrong.  Is there away to reference the source data from a group of sheets without using the wizard?  Or is there another suggestion on how to link this data back to the Master sheet?

Comments