Hi,

I have a spreadsheet that has loads of completed forms on. I have a formula that references to these sheets, up to 420. But there may not always be so many sheets, as soon as I update the links, the formula is broken for good.

I would like the formula to stay the same weather the sheet is refers to exists or not!

Please help 

=IFERROR(CONCATENATE('SHEET (2)'!N25,'SHEET (2)'!O25,'SHEET (2)'!P25,'SHEET (2)'!Q25,'SHEET (2)'!R25,'SHEET (2)'!S25,' (2)'!T25,'SHEET (2)'!U25,'SHEET (2)'!V25,'SHEET (2)'!W25,'SHEET (2)'!X25,)," ")
Turns in to:

=IFERROR(CONCATENATE(#REF!N25,#REF!O25,#REF!P25,#REF!Q25,#REF!R25,#REF!S25,#REF!T25,#REF!U25,#REF!V25,#REF!W25,#REF!X25,)," ")
I need it to stay the same weather the sheet is there or not!