HELP to make a Kinda of a Sheet comparison

This spreadsheet took some extra work because of how the data in the text file is organized.

On the control panel sheet enter the following data.

Cell B2 – enter in the path name to the directory or folder that contains the data to import.

Cell B3 – enter the name of the text file that contains the current data. Please note, that if the file has a date stamp you may be able to compute this name. For example, the file might be called Current 20170302.txt. ="Current "&TEXT(TODAY()-1,"yyyymmdd")&".txt" would compute the name of the file for yesterday.

Cell B4 – enter the name of the text file that contains the selled data.

Make sure to include the .txt extension.

Click on the Make Report Button. The program will check to make sure that the source files exist and imports them. The program then creates the report on the Report sheet.

The other sheets that are shaded in brown can be hidden if you wish.