Hello,

I have an issue I can't seem to find an answer to, which I believe is
doable.

I have a worksheet named RU (for Rollup) which pulls information from
3 other worksheets named "RCA","RCB", "RCC" through an Index Match
formula.

I am hoping to insert into the formula the name of the tab I would
like the formula to search from. I would like formula to look for the
name of the worksheet in a cell within the same row, find the
worksheet and then apply the index match formula. That way I can just
the name of worksheet it looks from by changing the value of the cell.

I have tried researching the INDIRECT function but I can't seem to
find an example for what I am trying to do. Any help would be greatly
appreciated. Thank you for your time in advance.