Hi all,

I am trying to figure out how to substitute the ending tab name used in the
sum consolidation formula, e.g. =SUM('04:03'!C46), where tab name "03" need
to be changed according to selection, INDIRECT function seems not working
here, please help! Thanks a lot,

Seaq