Section wise summarize the data into one sheet from other work sheets

Hi,


I required a formula help (Sum product or sumifs with Indirect function) to prepare a summary section wise separately by referring the "Ref Number",

values to be return automatically once entered Ref Number in cells Column A of summary sheet with including related descriptions against ref numbers.

Sample workbook enclosed for reference.


Thanks in advance,