Portion of formula in another cell

I am attempting to use a formula which has a part of the formula contained in another cell. The desired formula (which does not work would look like this:

Please Login or Register  to view this content.

where "$A$3" is the name of the worksheet [using the '=MID(CELL("filename",$C$1),FIND("]",CELL("filename",$C$1))+1,256) technique].

I believe that I have attached two files which explain the problem more thoroughly.

Thanks, Dell.

I have tried the INDIRECT function and it does not work on closed workbooks (as you also said).

The free addin INDIRECT.EXT (as discussed on a couple of closed threads) says it works on Execl 2007 but I have Excel 2010. I have tried to use it but I might be doing something wrong since I can not see the added functions or it does not install in Excel 2010.

I was trying to use the SUMPRODUCT function since it works on closed workbooks.

I am really trying to get a formula that reads the worksheet name and uses that worksheet name as a part of a workbook name that I can extract cell values from a specific worksheet within that workbook even when that workbook is closed. If this can be done I can make copies of the worksheet and only change the worksheet name and all of the included formulas will be updated automatically.

This approach would be easy to implement and would help to prevent spreadsheet errors. PC memory limitations prevent having all workbooks open at the same time.