I want to return a value from a cell on another worksheet which worksheet is sellected based on a value in the first row of the current worksheet. This page is an agregate of information organized by date. In the frist row I have a list of dates (one per week) and then there is a coresponding worksheet in this workbook for each date. Each week that worksheet is populated with the weeks numbers. I want to pull the week totals to a summation worksheet that can be combined with other info to make a chart that is updated weekly with the latest info. What is a formula to select the worksheet based on the value in row one of the column?