Thank you. This is great, but there is an anomaly....
1. If you delete the contents of any data from the Worksheet from where the data is pulled from e.g. Cell 'Attendance'B6 "Total", the formula, not only returns a blank or #N/A, as expected but it also populates the next cell down it...