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?