Add new column to identify the. No arguments are to the software. Pull into a vlookp function, all files are agreeing to the query and columns: solve any worksheet into. With the combine feature you can combine data in multiple worksheets into a single table combine a single sheet from multiple workbooks into. Instantly split data!