Consolidating Excel Files?

[hyme]

Howdy:

I have some quick questions about Excel in VB6. Let explain, I need to consolidate many excel files into one (All excel files are identical!). I am not looking for anyone to to the work for me, I just need to get started in right direction. Thanks

Example:

I have a new file Test.xls and I am opening existing files Book1.xls, Book2.xls, etc

I want to put the contents from Book1.xls and Book2.xls in Test.xls

If column Book1.xls has the first 5 rows of column 'A'
A1 = 1
A2 = 2
etc

and If column Book2.xls has the first 5 rows of column 'A'
A1 = 1
A2 = 2
etc

I want Test.xls to equal the sum of book1.xls(A1) and Book2(A1)
A1 = 2
A2 = 4

I am stuck @ this point. I have the Test.xls and Book1.xls and ready to fly.

Thanx

Hyme