Auto Expanding Tables

[marlz]

I am attempting to build a worksheet that will help summarize a month to month position for my company. I was hoping to have a table in which you could click a spin wheel, or type a new date in, and it would perform a lookup type function, return all the necessary values, and then adjust the size of the table to fit the new set of information. The lookup function needs to be able to look up based on 3 criteria. The column it returns are numerous so I need to be able to adjust that. I would prefer it to return in a table format for visual appeal (much like it is already displayed as.) Because I will be refreshing the data on sheet5, the function needs to understand i want it to return ALL data that matches the lookups, even after that data may have changed.

In the attached file, I want the layout to be similar to the ERCOT months and PJM months tabs, but instead of having multiple months, i want to have a single table that will adjust to the month you choose to look at. The size of this table will adjust automatically with the amount of trades the look up was able to find.

AT the moment I was using the following function for my lookups, but i dont know how to make the table adjust automatically

=INDEX(Sheet5!A:AC,MATCH(1,(Sheet5!$A:$A=Sheet1!$A$1)*(Sheet5!$L:$L=Sheet1!$B$1)*(Sheet5!$D:$D=Sheet1!$C$1),0),3)

Finally, I will be summarizing the information in the summary tab, which i will likely do through some of my own functions.

Help would be greatly appreciated!

Trade Summaries 2014 forum.xlsx

EDIT: I forgot I had the issue that the function I pasted above only returns the first line that it finds, and not all of them. I had used the following function before, but now I need it to be able to match against 3 different criteria. Either that, or someone would need to help me think of a potential work around to get this table operating properly.

=INDEX('ERCOT Raw'!$A:$I,SMALL(IF('ERCOT Raw'!$A:$A='ERCOT Months'!$A$905,ROW('ERCOT Raw'!$A:$A)),ROW(3:3)),2)