Calling contents from another sheets based on a call

[ajaysomasi]

Hi, I have 4 sheets in my workbook.. Summary, Sheet1,2,3.. Summary has all the sheet names (A1 to A3).. Each of Sheet 1,2,3 has numbers from A1 to A10... What I want to do is, in Summary sheet, against each of A1 to A3, I want to list down maximum of A1 to A10 in each Sheet 1 to 3 by referencing to the Sheet names in Summary tab..

Actually, I have many sheets like that so not practical to go to each sheet to pick up maximums.. Please tell me if there is any excel formula or a VBA code where I quickly get the result..

 

[Takae]

B1 of Summary sheet
=MAX(INDIRECT(A1&"!A:A"))

Please try it.