how to get totals from varying amount of sheets

[Mick Hassell]

I have a spread sheet to price up jobs each section of the job has its own sheet, the price is always in cell J1.
I have a totals sheet where all the values are recorded to give a grand total what I want to do is put code in to add the J1 cells in all sheets automatically a job could be anything from 2 sheets up to 100
Thanks in advance
Mick