I need to add text from one worksheet to another worksheet. I have the
follwing formula, which does not work - =IF(AF29'Deal (1)'!AF29,C3,'Deal
(1)'!AG29)

AF is a numerical number that could increase if P29 is "No." This is the
formula in Cell AF: =COUNTIF(P29,"No")+'Deal (1)'!AF29

Here it is in words:
If P29 increases from the previous worksheet, then the answer is a text
answer (In this case, what is in C3). I can get it to do that, but I need it
to add the text answer from the first worksheet to the answer in the current
worksheet, separated by a comma if possible.

So, on worksheet One, If P29 is "No", then the answer is "Commonwealth." On
Worksheet Two, If P29 is "No", then the answer should be "Commonwealth,
Tribute." The deal name changes on each worksheet, so the string of names
would increase on each new worksheet created.