Home Office Merge multiple excel files into a single spreadsheet MS Excel 2007 Merge multiple excel files into a single spreadsheet MS Excel 2007. When I have a Vlookup in a loop that does something like CellsfillRow, 2. Value Application. WorksheetFunction. VLookup Mtge, Sheets Reference. Range. SmartPCFixer is a fully featured and easytouse system optimization suite. With it, you can clean windows registry, remove cache files, fix errors, defrag disk.