Return multiple values across multiple spreadsheets - Excel 2010

Hi Excel Forum community,

I have a question that I cannot find an answer to, even after searching for about half an hour on this forum. I have found many existing topics on returning multiple values, but the functions do not seem to work for me. I apologize in advance if I overlooked a similar topic.

I have attached a spreadsheet for your reference. The red values are those that are intended to be derived from the formula.

Hopefully I can explain this without making it too complicated. The base data tab could have anywhere up to 50,000+ entries, made up of around 30 unique records (each of the 30 unique records would be sent to their own tab) - I've only included three records in my example .

In the example, I want to paste all of the Record1, Record2, and Record3 value's in their appropriate spreadsheet, referencing the information in the Control tab.

Using a simple vlookup as an example, it would look something like this:

=VLOOKUP('Control List'!$B$2,'Base Data'!A:B,2,FALSE), but obviously returning all the Record 1's from the base data tab. As I stated before, there could be tens of thousands of records so the formula would have to be flexible.

I've read up on the array functions, but still cannot seem to get them to work. Could someone spare some time to help me out? I would greatly appreciate it.

Thanks!