VBA macro for evaluation of several excel files

VBA Project The goal ist to write a macro for the evaluatio of a set of similar excel files into a matrix. The output matrix shall have the names of the relevant excel files on the x-axis and choosable question items on the y-axis. The filling of the matrix shall be determined by several if/or scannings. Functions: Input: 1. Folder in which about 30 files in the xls und xlsx format lie. 2. Question name that shall form the x-axis. Selected either per keyboard input or cell reference. 3. Area that shall be searched (worksheet!D1:D5) 4. Choosing criteria depending on which the content of the matrix is produced A: Initialization After the start of the macro and the selection of the input and output folders the following window shall be displayed. Changes are welcome as long as the functionality remains the same. B: ___________________________________________________________ Question:|________| selection of worksheet and cells |________| if cell |________| then fill in matrix |________| if cell |________| then fill in matrix |________| if cell |________| then fill in matrix |________| else then fill in matrix |________| |+| button for other if question ------------------------------------------------------------------------------------------- |+| button for next question | finish and run VBA | ____________________________________________________________ C: Output The new excel file that is generated might look like this: name of Excel A B C 1: Input question 1 0 0 1 2: Input question 2 1 1 0 Example The goal is to evaluate the excel files TableA and TableB in the folder D:/tables. The selected question 1 is a referenz to the field A1 of the first worksheet. If the content in this field is [n/a, none] or the field is empty a 0 shall fill the relevant cell. Otherwise the content shall be 1. The relevant cell in the output matrix is the point of intersection of the x-axis file name and the y-axis question. this process shall be repeated for the choosen number of questions and written in the same output file TableC. Please find the files for the example below