I have 14 files on a network in different folders that i need to consolidate
data from. This was done so only the individual and myself could see the
files (security). I tried the consolidate function (excel 2007) but I get a
reference error.

Do I need to have all workbooks in one folder?