Hi,

Presently, I consolidate data from 60 different files, each consisting of
about 9 sheets. Right now, we have to wait until all data is completed before
we consolidate. I was attempting to set it up by creating links to source
data so as data is entered, it automatically adds up. This process has to be
repeated every year, and it is tedious.

The question is, how can I consolidate data from a consolidate template
where data changes from year to year, so I don't have to go through this
process every year?

Please help me out. I'm deperate. I DO NOT want to do this every year. Also,
the create links also gave me some problems.

Many thanks for any assistance.

Nanika V. Brathwaite
Ministry of Health
Bahamas.