I hope i can get some help i am starting to loose the will to life at the moment. I have 8 different .xml work books that auto update from the net once a day i need all 8 files to be in one workbook on a single table. the reason i need this is because i want to use the single table as the source for my vlookup in another work book .
i think i have tried most things i can but sadly my knowledge is not great so i ran out of ideas a while back