VLOOKUP Multiple Sheets using VSTACK

This video shows how to use VSTACK with VLOOKUP (can also be used INDEX MATCH or XLOOKUP) to search different worksheets in one file.