Hi to all excel experts out there...
I am trying to find a way to consolidate data from several workbooks into one however the data must come from the separate workbooks and has to be updated everytime the consolidated workbook is opened.
There is a nice twist to this one aswell... the data...