vlook up formula

Vlook up Formula Needed   i need  a formula where everyday I can put a new sheet and it will automatically add any matching notes from previous sheets. I want to find & match the information found ...