Macro For Consolidation (with Pics)

I have let's say 3 workbooks with 1 sheet in every book.
Sheet in first wb named "SD_Romania". It looks like this:

Sheets in other workbooks named "SD_Bulgaria" and "SD_Poland" (there are more than 3 workbooks, just an example).

What I need to do is to write a macro that can extract only "Outlook" row data from all books and worksheets into new workbook. So that data will be structured like this:

BM and KF_TYPE are constants. REG should be taken from worksheet name. VERSION should be taken from A1 column (3 chars, starting from 8 char).
Period should somehow be transformed from "March 2008" to "32008".

The macro should look search for information in all opened workbooks, regardless of their names.

This is a hard macro, I guess. But unfortunately I don't have a clue how to write vba macros