Hi,
I have sheet1 as main sheet. in SHEET 1 i have Standard Charted Bank.
and there are more than 20 sheets in 1 workbook that containing the record of above bank.
i have to find the Values from each sheet and put in SHEET 1.

Which formula should i use and how

Please help