How can I create a formula to automatically transfer text from merged cells
on one worksheet to a single cell on another worksheet? This would operate
like a summary sheet with the data transferred automatically. I tried the =
and clicking on the merged cells but I keep getting a zero.