I have automated a time sheet that copies and saves each time period in a new
worksheet. Each sheet has Regular Time, Overtime, Sick, Vacation, etc.

On my home page, I would like to be able to add all of the 'Regular Time'
amounts from each sheet. The individual time sheets are not created until
the time sheet is completed and printed, so I can't simply write a formula to
pull information from a worksheet name.

In Quattro Pro (I know...Quattro what?), there was a 'bullet' function that
would do this. Does anyone know of a way to sum all of the 'B1' cells in a
spreadsheet?