Hi,

I'm trying to develop a way to gather information from several excel files into one that will analyse all the data. I want to collect, for ex, named ranges A, B and C from files 1, 2 and 3 and then display that data in file 4, where I will display that data in form of a chart (i'm guessing pivot tables here are essential).

What's the best way to accomplish this? Writing VBA code to copy data from those 1, 2 and 3 files to file nš4?

I'm sorry if it's confusing..