Debug Google Sheets Automation Error

When we install/create the sheets by the external call using apps script, sheets are created but some of the sheets show errors. (This may be due to the relationship between the sheets or some other reason ).

We have tried multiple approaches but still the problem is occuring.
1. We have tried to creates sheet(s) orderly starting from the base templates
https://docs.google.com/spreadsheets/d/1uXmUvFkFYFUty-oSTWiaZhRKd_jFqpEFwjIpUveZ4RM/edit?gid=1111072575#gid=1111072575
2. We tried changing the order as below
Order #1;
1. Start Here
2. Data
3. Categories
4. Balance History
5. Accounts
6. Transactions
7. Investments
8. Definitions
From 9 Rest of the sheets will be created

#Order #2;
1. Start here
2. Data
3. Definitions
from 4 rest of the sheets will be created

Order #3;
1. Start here
2. Data
3. Categories
Finally Definition sheet is created

But still the problem is occurring. Please check the video about the issue.
https://www.awesomescreenshot.com/video/41208331?key=3611241ea6ec72af36fa05636ff3ce5a