Hi,

The INDIRECT function may do what you want.

As you did not provide enough details, lets say the data you want is either
on "Sheet1" or "Sheet2:, both in cell A4.
On "Sheet 3" place the sheet number that you want to refer to in cell B6 and
place the following formula in another cell
=INDIRECT("Sheet"&B6&"!A4")

Hope this helps.

Sean


"Anift" wrote in message
...
Hi,
I have a file with 30 Worksheets for date March 1 to March 30, with some
daily sales data, Now I want a folmula by which I can retrieve the figure
from a particluar date's worksheet which I specify, or in other words, Is
there any formula where it can move from one sheet to another and retrieve
values.

any sugestions will be highly appreciated