VLOOK UP MACRO

[jaimecastellanos]

Hello, I have a spreadhseet to keep track of project status, but im making a worsheet called "POCFinder" with a dropdown list with all my projects (B3), next to it there is a hyper link to take me to the "POCData" worksheet with formula (=HYPERLINK("#"&CELL("address",INDEX('POC Data'!D6:D240,MATCH(B3,'POC Data'!D6:D240,0))),"Go Project Data")).

This last formula works just fine, but what I need now is a macro that works like a vlook up and copy and pastes the information from the data sheet to the finder sheet

this is the table where I want the data to display, the POCdata sheet has many tables exactly like this one, Every table is above the other one

so on and so on, how can i make the display button to pull data from this sheet? Thank you experts!!