using contents of cell to name a worksheet reference

[Guest]

My first sheet is an overview sheet for a budget. I have the names of all
the other sheets in the first column and some code to pull each worksheet
name and put in in that column on opening. In the second column I want to
pull the name of the worksheet from the first column and use it to reference
a cell in the corresponding worksheet.

For instance, Sheet1 is Overview, Sheet2 is Drywall. When the book opens
"drywall" will be put in cell A2 of Overview. In cell B2 of overview I want
the formula =drywall!A1 (the A1 cell in each of the other worksheets is a
subtotal) were the word drywall is a reference to Overview!A2.

I tried ='A2'!A1 (in Overview B2) but it wanted to update values for A2.
Does this make sense? Thanks.

 

[Guest]

forget it -- found Mr. Petersons response to same questions. Thx.