Based on data entered (ID_Location) I need to extract information from
another worksheet. I have used VLookup successfully to extract the first
occurrance of the information.

VMM_Sig_Name = Application.WorksheetFunction.VLookup(Range(ID_Loc ation),
VMM_Workbook.Worksheets(ShortVMM_FileName).Range(" B6:P2000"), 3, False)

I do know the number of times the "ID" shows up in the other worksheet.

Num_Of_IDs_In_VMM =
Application.WorksheetFunction.CountIf(VMM_Workbook .Worksheets(ShortVMM_FileName).Range("B6:B2000"), myID)

What is the best way to extract all the information? Use multiple VLookups?
Obtain the address, in the other worksheet, of the first occurrance then
conduct a copy and paste?

Example:
ID to lookup, fisrt run = 100h, second run = 025h,

Lookup Worksheet information:

Column B Column D Column P
000h A Desk
000h B Chair
000h C Computer
100h A Apple
100h B Orange
100h C Pear
100h D Peach
100h E Grape
025h A Tomato
025h B Beans
025h C Cucumber
025h D Pepper

Thanks