Combining Indirect Function with Transpose Formula

I have used the transpose formula (Array) to extract the data from various sheets (sample data only one sheet)


In Col A on the summary sheet , I have various names which refers to the applicable sheet name


I would like to use the indirect function to combine with the transpose formula using the sheet name in Col A to extract data from B1:B5 for each of the ageing periods

I have tried to use the indirect formula, but get #Ref!


I have attached a sample workbook


Your assistance in resolving this is most appreciated