I have a macro that creates worksheets based on a list (tasks) on Sheet1. On
Sheet2 in column A, the worksheet has the same list of tasks. The formula on
Sheet2 cell A3 is ='Sheet1'$b$15. The result is "Maintenance" which is the
first task on Sheet1 and will be the first new worksheet the macro is run.

I would like cell B3 on Sheet2 to be ='Maintenance'$C$89. Is there anyway
to write a formula that will look at the result of A3 and let me use that for
the worksheet function?