Macro To Compare Security Codes

I have 4 worksheets in a workbook: “choose security”, “download”, “MC” and “Lending”,

In the choose security” worksheet in CELL A2 is an HEX code, i.e. stock code.

2. In MC worksheet is raw data of all holdings related to various p’folios and securities, the information we need from this worksheet is,

a) p’folios, which are in column A,
b) Holdings which is Col B
c) Security code i.e. stock code which is in Col D

I need a macro or a formula to look at what security code is in “choose security” worksheet CELL A2, then look for this security in worksheet “MC” Col D, once matched, copy the data for this security to worksheet “download” and paste in CELL A3, I only need p’folios and holdings to be copied to “download” so data in Col A and B.

Once data has been copied to worksheet “download”, I then need another macro or formula to repeat step 2, but this time the macro will be looking at worksheet “Lending”,

a) P’folios, which are in Col B
b) Security code is in Col D
c) Holdings is in Col H

Once the macro or formula has found a match of security code, it will then copy the data from Col B and H to download worksheet CELL E3.