Formula nesting with additional sheets

[bronkista]

Hi,

I know that a formula can be used while referencing a cell on a different sheet.

But can it also be used to reference cells on sheets that are just about to be added?

[ZENITH]

You can reference cells on sheets that are nonexistent but they will give an #REF error until the sheet exists and they are edited again.

[bronkista]

Yeah well that's what I'm also expecting..

but is there a work-around on this?
could it be possible to just add the existing sheets