reference to the cell which in turns refers to the worksheet based on the value of the cel

Dear experts.

My requirement is as below.

In a excel file i want to enter the formula which refer to the cell. The data written in the cell refer to some other worksheet.

The formula should give the final result of the cell in the other worksheet.

For Example

below Data is written in cell A1 and A2 and A3 of worksheet "june" and in another worksheet named "May" 9876 is entered in cell number D45.

Cell A1 Data is "May"
Cell A2 Data is "D" This D should correspondence to the Column D of the Worksheet named "May"
Cell A3 Data is "45" This 45 means the formula should correspondence to the Row 45 of the worksheet named "May"

Requirement for the formula

We need to use the formula in cell A4 and the result of the formula should be 9876.

thanks in advance.

Dear Support team

i think i am not able to explain the requirement.

i am trying to explain the requirement as below once again.

there is one formula below.
='YTD Feb-14'!B4
='YTD Feb-14'!B5
='YTD Feb-14'!B6
='YTD Feb-14'!B7
... and so on.

next month say mar-14 i had to change the month physically so that the values will be updated automatically.

The requirement is that i need some indirect function which can be used within the formula so that i need to change the month only once in the entire worksheet and all the Feb-14 month changes to Mar-14 automatically.

like

='YTD(indirect(a1)'!B4

this A1 is cell location within the same worksheet where i will write the month as "Mar-14" and all the formula will be automatically starts refering to Mar-14 worksheet.

please help.