Hello,
I have this formula, which works great for copying up or down, but doesn't work when copying left or right.
=INDIRECT("'WBS"&ROW($A24)-(ROW($A24)-COUNTA($A$18:$A24))&"'!"&"E$12")
The issue I believe is the last "E$12".
It is in parentheses, which is fine for filling up or down, but...