Macro Importing Selected Text Files into Temp Folder and then Separate Worksheet Pulling Selected Areas

[maninblack]

Hello, I am wondering on how to prepare a Macro code in Excel 2007 to initiate the movement of text files into a temp folder or separate sheet in the excel document and have data recovered onto the main page. So Sheet1 will hold selected data from the files that have been entered on sheet2. Sheet2 has the directory of the files in cell E2 (C:/data/2012/), and would like to pull data from text files entered in cells C6 (run001) to C26 (run020). And the selected location of the data that I want to be pulled from these text files are on line 26, starting on space 15 and is 10 characters long. I would like to also produce a macro button for this as well on Sheet2.