Can a formula be "built" referencing text content from another cel

Hi, and thank you for your help.
I have run across this need many times...is there any way to use to contents
of one cell, to construct a formula in another cell?

Here is my particular requirement. I have worksheets named January,
February, March...etc.

On a separate Summary Worksheet, I reference the same cells on each of those
sheets.

For example, I may have in 3 adjacent cells, =January!A1 =February!A1
=March!A1 and then in the next row:
=January!A7 =February!A7 =March!A7 etc.

It would, obviously, be much easier to "build a formula" by creating a row
with the months name and then reference that row in another formula. Is this
possible? Or is there another way to accomplish this?

Thanks for your help.
Pradhan

The key is to use INDIRECT
In your summary sheet,
List the sheetnames in B1 across, eg: January, ...
List the cell references in A2 down, eg: A1, A7, etc
Put in B2: =INDIRECT("'"&B$1&"'!"&$A2)
Copy across/fill down to populate
voila? hit the YES below
--
Max
Singapore
---
"Pradhan" wrote:
Hi, and thank you for your help.
I have run across this need many times...is there any way to use to contents
of one cell, to construct a formula in another cell?

Here is my particular requirement. I have worksheets named January,
February, March...etc.

On a separate Summary Worksheet, I reference the same cells on each of those
sheets.

For example, I may have in 3 adjacent cells, =January!A1 =February!A1
=March!A1 and then in the next row:
=January!A7 =February!A7 =March!A7 etc.

It would, obviously, be much easier to "build a formula" by creating a row
with the months name and then reference that row in another formula. Is this
possible? Or is there another way to accomplish this?

Thanks for your help.
Pradhan

Not just "YES"...AWESOME!!!! I can 't tell you how much time this will save me.
Thank you, and regards to Singapore...one of my favorite places to visit!

Pradhan

"Max" wrote:

The key is to use INDIRECT
In your summary sheet,
List the sheetnames in B1 across, eg: January, ...
List the cell references in A2 down, eg: A1, A7, etc
Put in B2: =INDIRECT("'"&B$1&"'!"&$A2)
Copy across/fill down to populate
voila? hit the YES below
--
Max
Singapore
---
"Pradhan" wrote:
Hi, and thank you for your help.
I have run across this need many times...is there any way to use to contents
of one cell, to construct a formula in another cell?

Here is my particular requirement. I have worksheets named January,
February, March...etc.

On a separate Summary Worksheet, I reference the same cells on each of those
sheets.

For example, I may have in 3 adjacent cells, =January!A1 =February!A1
=March!A1 and then in the next row:
=January!A7 =February!A7 =March!A7 etc.

It would, obviously, be much easier to "build a formula" by creating a row
with the months name and then reference that row in another formula. Is this
possible? Or is there another way to accomplish this?

Thanks for your help.
Pradhan

Welcome, on both counts !
--
Max
Singapore

"Pradhan" wrote in message
...
Not just "YES"...AWESOME!!!! I can 't tell you how much time this will
save me.
Thank you, and regards to Singapore...one of my favorite places to visit!

Pradhan