I have been trying to ling cells in 9 worksheets to a totals page and cannot do this can anyone help please.
If it's possible to post a copy of your spreadsheet, you'd be far more likely to get a good and relevant response. If the actual contains confidential data, then make a facsimile with fake names, etc.
There are multiple ways to do what you're asking; the more you can show us or tell us about your actual situation, the more helpful we can be.
Questions that I'm sure any of the experts here would want to have answered (and seeing your spreadsheet would answer some of these: