Thank you for help by using this formula the answer is coming #NAME? where I want Nil.

The amount will be "Nil" not a Zero value put in all six sheets.