I have a workbook with several sheets. One of the sheets is a "recap" sheet
reflecting specific cells from all the other sheets in the workbook. I am
using " + " and then go to the specific sheet and cell I want to reference
from (all text from merged cells) I get an error or the actual formula in
the cell. I have tried to format the cells all different ways to no avail.
This is just not working on this specific recap sheet. If I try to do this
on the same sheet the referenced cells are, it works fine.

HELP!!