Excel: Function using worksheet name

I'm using a worksheet with multiple spreadsheets. Spreadsheets named "Day1" to "Day10" and the eleventh spreadsheet is the summary sheet. Each spreadsheet has its own date. Calculations on the spreadsheets end with an colum ("AA10" to "AA100") with closing values. Depending on the date on the "Summery Sheet", i need a formula to lookup the date on the spreadsheets "Day1" to "Day10" and return the values from this spreadsheet to cell "C10" to"C100". thanks you!!

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of April 20, 2014.

For more resources for Microsoft Excel