MATCH Function across multiple sheets

Hi,

I have been trying to use a MATCH function across multiple sheets so that I can pull information into a summary sheet. What I cant figure out is how to make part of the MATCH function dynamic so that it links to a drop down box with the names of the different sheets. Its a little bit difficult to explain in words so I've attached an spreadsheet that hopefully makes it clearer.
I have been trying to use an INDIRECT function with the MATCH function but I cannot get it to work.

I appreciate any help you can give me.

Thanks!

Thanks a million man! I was close but just could not get it to work.

I actually have another question (now that I have "figured out" one thing I am being asked to do another!). Again this relates to calculating something in one sheet but pulling data from multiple sheets.

What I am trying to do here is calculate longer term returns by geometrically linking monthly returns. That part is fine and I am just using a mixture of a PRODUCT and MATCH formula. However when it comes to pulling information from multiple sheets I cannot see how to amend either function to achieve this.

The way the calculation works is that you specify a start date, cell F29 in the attached, and the number of months you wish to calculate a return for (F30). Then F31 calculates the last month and using the MATCH and PRODUCT formulae I can calculate the 18 month return.

Now if I have multiple sheets, one for each portfolio, and the dates and returns are always in the same columns how can I write a product formula that can link to a list of sheet names so that when I select a different sheet it will calculate the returns from that sheet?

Thanks!