Pull all data matches from HUGE workbook, with duplicates

I need to pull information from a workbook with about 2.8 million cells per tab. I can't filter it, because Excel explodes. So I need an alternative way of doing it.

I have data set A in a smaller workbook.
I need each instance of data from A pulled from larger workbook, B.
From B, I need two columns of data reported.
Also, I need all duplicates, so Vlookup isn't being useful.

Any help is appreciated, and let me know if you need clarification.

MS Query seems like a good way to get the data you are looking for.

Go to Data -> Import External Data -> New Database Query. From here select "Excel Files*". Browse to the excel document location you want to query from.

Now a query wizard will start. The wizard has only limited use, IMO. Cancel out of the wizard and continue on the Query editor.

From here you can Select the fields you want to query.

You can also add in criteria. Click the "Show/Hide Criteria" button. (It looks like a funnel and a pair of glasses) Drag-and-drop the field that you are adding criteria to into the criteria section. Then just throw in something like [Parameter name] to make it a paramater. (note that the brackets are important).

Return the sheet. It will pop up a box to have you choose the cell destination. You can also change the properties of the query to match your desires (you may want to make sure that "insert new rows" option is turned on). Most importantly, however, is that you can define the source of your parameter(s). Click the "Parameters" button. Define the cell that contains the criteria.

Complete through all the queries and VIOLA! Rinse and repeat for each value you want to query.

I will try that. It looks promising so far, so i'll post again later if this indeed solves it. Thank you.