Sum cells in as yet uncreated worksheets

Hello

I am trying to reproduce a formula I found in a locked worksheet. Copying and pasting formula has not worked.
Formula is =sum(‘Day (0):end’!d16).
The formula is designed to add values automatically when new sheets are added. If it helps am adding new sheets via a macro.
Please help