Indirect & offset formulae - Urgent

[Arlette]

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?

 

[Mike H]

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]

Thanks for your reply. But i believe you have not understood my
question. I want the figures from a fixed column in every sheet to
appear in the respective columns in the main worksheet. The main
worksheet has headings for the various tab names and the data from
those tabs should appear in the main worksheet for the corresponding
date.

 

[Fred Smith]

What happens if you have duplicate data? If you have something in, say, cell
C37 on one worksheet, and also have data in cell C37 on another worksheet,
what do you want to happen? Should one override the other? Or should they be
summed? Or is this an error?

Regards,
Fred.

Thanks for your reply. But i believe you have not understood my
question. I want the figures from a fixed column in every sheet to
appear in the respective columns in the main worksheet. The main
worksheet has headings for the various tab names and the data from
those tabs should appear in the main worksheet for the corresponding
date.