Input: Excel files with possibly missing columns of data.
Download sample input files here Sample files
Goal: Setup a workbook formula that pulls the data from all the sample files and puts it at one place. Further, the workbook should give either errors or warning based on which columns are missing.
Hint:
Notes: