Import changing text file to Excel

We wish to make the Excel portion as "Seamless" as possible so neophytes need only view data, not mess with importing files, etc. So, maybe VBA is the way to go if necessary.

This is what we currently have in our text file:

1) Automation system dumps new data every 2 hours to an ever growing file. The file is "apended" so it continually grows containing the new (and existing) data. Current file is on C Drive c:/Utility Data/2005/April/KW Trends.txt. There are currently 5 columns in the text file:
A- Date/Time
B- kW max (max reading over the month span)
C- kW average
D- Total kWh (over month span)
E- Outside air temperature

2) We want to "pump" that data into Excel every so often so graphs and charts(set up in excel) can be displayed to provide users with temperature and energy usage information. So, excel will go out and get the updated information every so often and auto update our charts. It will accumulate a monthly amount of data ultimately. Our calculations are:

A- Date/Time (unchanged)
B- kW max (highest reading over the range of the month)
C- kW Average (simply an 'average' calc. results sent to graph)
D- Total kWh (simply a 'total' calc. Results sent to graph)
E- Outside Air Temp (Min, Max, Ave)

3) We will probably set up a whole year's worth of folders and report files in advance. If Excel can do it, we would want it to "switch" and begin gathering data from the next month's folder automatically at the end of each month, i.e.: c:/Utility Data/2005/May/KW Trends.txt, June, etc.

4) As for the Excel layout. We will have a couple sheets. The numerical data from the text file can go on the second or third sheet. The graphs can be on the first page (so they are readily accessable).

Setting the calculations and graphs and moving the data around in Excel are not a problem for us. Getting the data to excel automatically IS. The Excel file can be saved in the same folder in C drive as the text file, or another folder if you think it's better. We just aren't sure how to get Excel to go out and "get" the data and update itself.

Any VB help will be MUCH appreciated, or at least to help point us in the right direction would be MUCH appreciated. Thanks again.

Mark G