i have a master data like this.
A B C D
E
Customer Bank Bank A/C No. Branch Address

and on the second sheet, i would like to just enter the Bank a/c on the first
col, and the details will come out.

Please help me on how to do that. I understand that i need to have the same
coloumn name and stuffs like that, right?

Thanks in advance.

Regards,
Merlina