Hi

Can someone explain the difference between linking data from separate
workbooks and consolidating data?

I am currently using Excel 2003.

Could you also give me some examples of when to use consolidation and when
it is more appropriate to link? (if that makes any sense)

Thanks ^^