If there is file with name that is not in file list, which is new file, if there is file that no longer exist, which is deleted file, if file modified date is changed, which is modified file

delete intermediate sheet for deleted files and modified files, delete summary info for deleted files and modified files, create intermediate sheet for modified files and new files, append summary info of modified files and new files to summary sheet