I've never used macros before in Excel.

I'm trying to copy text from a file into a spreadsheet and copy a certain
set of out puts into another worksheet. 2000 times. (This is to compile
pertinent data provided by weather stations worldwide.)

So what I want the macro to do is to open up the text file, copy the text,
and put it into the spreadsheet.

Is it possible to automate the entire process? Can the macro move on to the
next file and repeat the process for the new data? If so, how?

All of these files are stored on a DOE website. Could I have the macro load
the data straight from that server or would I need to have all the files
local on my computer?

Sorry to bombard with questions.

Hope someone can help me.

Thank you!