Hi

it really depends on how you're worksheets are set out, if for example you
have sheet1, sheet2, sheet3 all with January in B3 and Hats in A4 and the
value for hats sold in January in B4 and you want on a summary sheet to add
all the hats sold across the three sheets, the formula would be
=SUM(Sheet1:Sheet3!B4)

is this what you're after?

Cheers
JulieD

"Excel Novice" <Excel wrote in message
...
Hi, I'm a basic user of Excel and need to know whether or not I can use
one
master spreadsheet to accumulate and total information from a number of
other
spreadsheets and if so how?

Many thanks