Dynamic Reference to Another Worksheet

Hi All,

I have an automatic quotation generating excel file, which generates quotation templates on to new worksheets with the help of a macro.
In the template, cell H27 is the 'Grand Total' cell where the total amount of the quotation appears. Now, I have a summary sheet at the beginning of the workbook which summarizes the quotation like Date, Client Name, Product & Net Amt. While the Date, Client Name & Product are present on the same cell of each quotation sheet, the Net Amt cell changes on each page as some quotations might have 2 lines or 3 lines or maybe 10 lines.

So kindly suggest a formula for me to use on the summary sheet to dynamically link the Total Amt from different sheets.

Care to upload a workbook with the problem you described above.