Assuming your cell with date choice is in A1.
Enter in B1:
=INDIRECT(A1)&"!C1"

HTH
--
AP

"Anift" a écrit dans le message de
...

In one sheet, I have to create a Cell with
list box with all dates from Mar -1 to Mar -31 and I want to retrieve the
values from the same "Date" sheet of " daily Figures.xls " which has
figures
of that particular date.

Let me give u one example:

Daily figure.xls has Daily Sales fugure in C1 of Mar - 2 Sheet ( One of
the
sheet from Mar-1 to mar-31 ), All I have to select a date " Mar -2 on a
different file and it will give me value from that Date's Sheet in Daily
figure.xls from C1.

Any help in this regard..