Okay bro, this is more or less a repetition of the last post of mine…
Cheers

                                                    INSTRUCTIONS
This attached excel workbook contains macros that will run when you mouse- click on the button with the caption “click here to run macro” on sheet1 .The program will  assume that all your data conform to the format seen in the sample(1).xls file you earlier attached in your post, and that they are all contained in sheet one. It also assumes that the data are formatted into two columns and 8 rows on each worksheet as seen in the samples.xls document you attached. The program assumes also, that all the workbooks have already been copied to a single folder where all of them can be selected with the mouse at once. If not, so please copy all the excel files into a single folder now.
The principal means of extracting the data from the sheets is like this

1. You click the button on this worksheet
2. A dialogue box is displayed
3. Browse to the folder where you have all you excel files already copied to, and select all the files
4. Click Ok on the dialogue box
5. The data in sheet 1 of all the selected files will be copied to the sheet 1 of this workbook sequentially, eight rows at a time, until all the workbooks have been exhausted.

The following image displays the data extracted from 4 excel files and have been copied to this single sheet.

INSTRUCTIONS
This attached excel workbook contain macros that will run when you mouse click on the button .The program will assume that all your data will all be as seen in the sample(1).xls file you earlier attached and are all contained in sheet one. It also assumes that the information is formatted into two columns and 8 rows on each worksheet. The program assumes that all the worksheets have been copied to a single folder where all of them can be selected with the mouse. If not, so please copy all the worksheets into a single folder now. The principal means of extracting the data from the sheets is like this

1. You click the button on this worksheet
2. A dialogue box is displayed
3. Browse to the folder where you have all you excel files already copied to, and select all the files
4. Click Ok on the dialogue box
5. The data in sheet 1 of all the selected files will be copied to the sheet 1 of this workbook sequentially, eight rows at a time, until all the workbooks have been exhausted.

Good luck!

Please post a reply if you find any difficulty.

Nope (as far as I know).Truth is, personally, I used to under rate the POWER of Excel.But I have come to know better.Under the hood, Microsoft had incorporated Powerful stuff such that you can turbo charge your Spreadsheets with great pep-up features. Infact I am of the personal conviction that Microsoft had done some great job with this Application Program (Excel)-Plz Note I am not a Microsoft employee!.
Excel prog becomes very easy when you already know VB.However it comes with a fairly reduced GUI set to work with.
I also grad with a major in Applied Geophysics but It would not deter me from learning how to do some shy stuff wity Excel (LOL).
For example you can come here and see the result a 'few' days attempt,
http://www.oauife.edu.ng/research/copine/
Download the package free from the page.
Please also note (If applicable) that apart from being able to use the mere spreadsheet interface,You actually would have access to the OS's  API through the use of the GUI based RAD environment installed for the wriring of PROGRAMME CODE we call macros,

If I were u (and I intend to be a good programmer) I'd advice you go for Assem prog.After all, it only adds value.