Thanks GTO for getting back to me and I am trying to put this in a very specific matter so as not to waste time.

Yes the Ticker Symbols are the file name and they are all on my Desktop folder called Historic Prices. (There is only 1 sheet with all the data on each file and it is called by the ticker symbol)

I would like to be able to enter a load of symbols into a spreadsheet (within a workbook) under a column called Ticker and then this will pull the corresponding ticker symbol file for each Symbol picked and load it into the workbook in the order of the symbols.

If I could just get it working for 4-5 symbols it would be great and I would try to do the rest myself then.

Again thanks GTO, hope this is clearer.