Not quite enough description - which cells in the summary sheet
contain the date and the worksheet name? What is the structure of the
data in the weather sheets, and what data do you want to return to the
summary sheet if you find a match?

You can do it with the INDIRECT function, and if you can answer the
other questions I'll be able to suggest an appropriate formula.

Pete

On Aug 13, 5:04*pm, William Blake
wrote:
I have a workbook with a summary worksheet and several weather data
worksheets. *The data worksheets have unique names but all have the same
structure. *I would like to construct a formula that would lookup data for a
specific day (refrenced in a column on the summary sheet) for a specific
weather data worksheet (also listed in a column on the summary sheet).

Is this possible? *Have I given enough description of the circumstance? *I
have an idea that would utilize the "choose" function, but that would not be
dynamic.

--
William Blake