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..