Excel VB help needed to fetch data from database sheet

Hi,

I have a worksheet. There are two sheets inside it. one is portfolio and second is summery. in database sheet I have list of clients. In a summery sheet I want appear portfolio sheet data in a summery sheet format.
what i am looking for??

1. in a summery sheet I will select only client name (cell marked in wooden color). Once I select client name according to that all fields marked in yellow will fetch data from portfolio sheet. I tried to do it with vlookup formula and got success to fetch address, bank details cell data. But when I come to downside where there are multiple data rows in portfolio sheet, there only first line is showing an if i copy/paste the same formula to next line than same data is coming.

please help.

Sample worksheet is attached.

SUMMARY (not Summery)

you need to write code, to fill in all the fields,after the lookup.

upon combo box update, run macro to:
get the clientid
Find client in Portfolio, row (r)
cell by cell , write data to Summary sheet....
summary!k5 = portfolio!X(r) 'address
summary!Q4 = portfolio!B(r) '1st holder
etc....

or make lots of nested VLOOKUPS.