How to take inputs from one table, plug them into a different table, and save a copy of outputs

Hello,

I have a question regarding how to take a row of inputs from one sheet, plug them into a table from another sheet, and save a copy of the results from the second sheet. That is the end result I would like to achieve. I will elaborate more below with specifics.

1) I have a workbook with 1 sheet. This workbook is called Analysis_Inputs and the sheet is called Inputs. It has a formatted table called All_Inputs with 4 columns that I want to be fed as inputs to another workbook. Each row of that table is its own set and I would like to iterate through each row.

2) The second workbook is where it takes 4 inputs and goes through some calculations in a table called Full_A. These calculations yield results that I want. This workbook is called Full_Analysis. The first sheet does the work and is called Analysis. The second sheet in this workbook is a summary of the first sheet and is called "Summary". 

3) What I ultimately want is to be able to save a copy of sheet "Summary" for each iterated row in workbook Analysis_Inputs. I would like each iteration to be saved to its own workbook, or to a different sheet within the same workbook. What I will then do is join all the resulting Summaries into a single table. This "table" is what my end result for this entire exercise. 

See my example excel files below. Workbook "Desired_Summaries" is the end result that I would like to see. 

I have very little experience with VBA code but some in Python and Matlab. 

Does anyone here have a good approach for reaching my desired outcome?

  <see new demo files in replies below>

Please let me know if you can't open the example files.