Arlette,

Try this

Lets assume your 'Main' worksheet is the first worksheet. To the right of
that insert a worksheet called 'First' and hide it.

The insert another worksheet called 'Last' on the extreme right hand side
and hide that.

Now in you main worksheet enter the formula
=SUM(First:Last!A1)
This will sum a1 in all sheets including any new ones you add provided they
are between the sheets named First & Last

Mike

"Arlette" wrote:

I have my main worksheet which needs to take in the values from a
fixed column from every tab. So as i keep adding a tab every week, the
data should flow into the appropriate cell on the main tab. How do i
do this using the indirect & offset formulae? Its pretty urgent and i
am stuck as i havent used these formulae before. Is there any other
method other than using the offset and indirect?