I use Excel (version 16.16.11) to calculate estimates/quotations. Each estimate consists of a multi-sheet workbook. The cover page of each workbook shows a project date, name and estimated cost. I want the values in these three fields to automatically be posted to a summary sheet (a master list) in another workbook. As I create additional estimates, I want each new set of values to post to a subsequent row in the summary sheet; i.e., first project, first row; second project, second row; etc.
What's the easiest way to create this kind of summary sheet?
I'm an advanced beginner. Thanks