I have 4 sheets in my workbook: sheet1, sheet2, sheet3, and master.
On the master sheet I have cell a3 which contains the word sheet1, sheet2, or sheet3 based on a formula
On the master sheet, I want to bring back cell B10 from either sheet1, sheet2, or sheet3, dependent on what cell a3 reads. How do I write the formula so excel understands I am looking for the data tab referenced in cell a3? Normally, if I knew it would be sheet 1, I know the formula would be sheet1!b10, but in this case, It depends on what cell 3 says as to which sheet I should pull from.
On the master sheet I have cell a3 which contains the word sheet1, sheet2, or sheet3 based on a formula
On the master sheet, I want to bring back cell B10 from either sheet1, sheet2, or sheet3, dependent on what cell a3 reads. How do I write the formula so excel understands I am looking for the data tab referenced in cell a3? Normally, if I knew it would be sheet 1, I know the formula would be sheet1!b10, but in this case, It depends on what cell 3 says as to which sheet I should pull from.