I think I understand your question, but let me summarize.
1) You have 8 workbooks.
2) Each workbook has one or more sheets.
3) You want to loop through each workbook and extract the info from
column A and H from each sheet  in the workbook and put  the info
into another workbook.

that sound right?

It's VERY do-able.
If that sounds accurate, let me know and I can help you with it.