It seems I’ve reached the limitations of Excel as it no longer works the way I require.
Basically I have a single controlling spreadsheet which controls many other spreadsheets. As I manipulated numbers in the controlling spreadsheet it modifies all the other spreadsheets and I get the results...