Auto-populate sheet referencing


I have multiple sheets that track project specific metrics that I want to compile on a "master" sheet that will act as a project database. Is there a way for me to use something like a VLOOKUP on a project # column in the master sheet to determine which project specific sheet to reference? This way I do not have to manually link every row (which corresponds to a different project) to the correct project specific sheet?