Does anyone have any suggestions on how to do following task in excel?

I get a workbook with 10 working sheets, which is named by
A, B, C, D, E, F, G, H, Summary, Temp
and I would like to display all cells' content in a specific sheet into
"Temp" sheet based on the sheet name in "Summary" sheet. For example, I type
"A" in cell A1 under "Summary" sheet, then in "Temp" sheet, all cell's
content will connect to "A" sheet and display what the cells' content under
"A" sheet, if I input "E" in cell A1 under "Summary" sheet, then in Temp"
sheet, all cell's content will connect to "E" sheet and display what the
cells' content under "E" sheet.

Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric