New Member - Looking for specific tutorials for specific macro? Links please?

Thanx for taking the time to read this post Great forum!

First, what I want to accomplish - then I'll give the rundown on how I'm doing it now (I will need to learn to write the macro)

I imagine the theory is something like this... to write a macro that:

(After running my export from my data entry software)
Automatically runs SPREAD.XLS from C:\Reserve\
(which by itself is a macro that opens a delimited text file SPREAD.TXT)
Automatically opens my TEMPLATE.XLS from C:\Reserve\
Automatically copies SPREAD.TXT (A) 1:4 and 16:infinity
Automatically pastes SPREAD.TXT (A)1:4 and 16:infinity, at TEMPLATE.XLS (I)1:4 and 5:infinity
Automatically launches my PARAMETERS FORM (Already made)

NOTE: Paste function NEEDS to be VALUES ONLY

Follow?

That's it.

Ok, so here's what I've been doing:

I have built a fairly extensive spreadsheet, free of macros, with extensive formulas, referencing static cells, to perform various functions.
So far the spreadsheet has been great for our needs and out clients.
(The spreadsheet is a financial document, which I have fairly well automated for our internal purposes - 30 years of expenditures, balances, interest, etc etc etc)

While it has progressed further, and older simpler version can be viewed in PDF Format here:
http://rdamidwest.com/files/Sample_R...preadsheet.pdf

(I1:I36 are what come in from SPREAD A1:4 and A16:infinity.... the old PDF rows vary, sorry)

First, I have built forms for some minor entry needs, which work well, but I would like more automation.

HERE'S THE SCENARIO (Excel 2010):

I export ASCII Spreadsheet Format from our data entry software.

I open the exported XLS file in Excel, which runs a macro to import the data and opens SPREAD.TXT
(I believe what is happening is, the software exports an ASCII text file, then the SPREAD.XLS runs a macro to import the TXT properly delimited)
I then open my spreadsheet 'template' with all my formulas
I then copy the export from it's XLS/TXT file into my 'template' - (little hairy, cause I need to first delete 11 rows of un-needed calculations - so it corresponds to my template correctly)
I then run the Form I created to enter certain perameters like: year, inflation rate, interest rate, and two separate accrued depreciation values

What I would like to do is:

Write a macro that:

Automatically runs the existing SPREAD.XLS macro to create and open the SPREAD.TXT file <Already exists
Automatically opens my TEMPLATE.XLS file
Automatically copies the correct rows from my SPREAD.TXT export file, then automatically pastes them into the correct location in my TEMPLATE.XLS
(Where A1 starts my export, but I need to paste it into my template at I1 while excluding rows 5:15, so I imagine this would have to be two separate copy/paste functions, rows 1:4, then 16:infinity... follow?)

So, I want to make a macro to automate this, rather than manually running SPREAD.XLS to run the macro, to open/create the SPREAD.TXT file, manually copy, manually open my template, manually paste into my template

Follow?

I can read. And I used to do some basic and visual basic code, and I've made forms (Granted, the coding was over 10 years ago)
But I think, given a point in the right direction, I can write this macro.

Any help in the right direction would be appreciated. I'm off to read up on macros in VBA, but help is appreciated.