Glad to know that. Thanks for the feedback.

Yes. After making any change to the reference range, you need to confirm it by Ctrl+Shift+Enter because this is an array formula and then drag the formula across and down as far as it is needed. This you have to do on every sheet.

Note: If you see the curly brackets in the formula bar, that means you have done it correctly.