Copying a Formula To Reference Multiple Worksheets

[Guest]

I am trying to build a table like this :

A B
5-Jul 7.33%
6-Jul
7-Jul
8-Jul
9-Jul

Where the value 7.33% is from this formula:

='Jul 5'!C8

The worksheets in this workbook are named 5-Jul, 6-Jul etc.

I would like to use a formula that will look at the text in Col A (eg
5-Jul), and pull the value in cell c8 of the appropriate worksheet.

Is it possible ?

Thank you in advance.

 

[Dave Peterson]

How about something like:
=INDIRECT("'" & A1 &"'!c8")

or if column A are real dates:
=INDIRECT("'" & text(A1,"d-mmm") &"'!c8")