Auto report update from one template quote

Hope you can help me,
we do quotes in Excel, then we retype everything into a separate Excel Workbook for reporting,
however I would like to be able to do a quote and once saved, the report is updated automatically.

We do approx. 200 quotes a week, I can get the lin between the two spreadsheets, but I cant figure out how to do the auto update?

Is there a way to do this?

Thanks so much

Attachment 638350

This is the mock up, I need to figure out however to auto insert the next line of info in the report as the quote on the right is updated.